Excel v查找 [英] Excel v lookup

问题描述

我正在尝试将两个电子表格合并在一起以进行价格更新，并且两个电子表格中的代码都相同，但它们不会注册。如果我键入其中一个代码，它将进行注册，并将提供相应的信息。我相信它与单元格的格式有关但我无法解决。

解决方案

I我试图将两个电子表格合并在一起以进行价格更新，两个电子表格上的代码相同，但它们没有注册。如果我键入其中一个代码，它将进行注册，并将提供相应的信息。我相信它与单元格的格式有关但我无法解决它。

你们如何合并它们？

你们如何合并它们？

我正在使用v查找并选择用于查找的代码单元

我正在使用v查找并为查找选择代码单元

你能告诉我们使用的代码（或公式）吗？

I am trying to merge two spreadsheets together for a price update and the codes on both spreadsheets are the same but they do not register. If i type over one of the codes it then will register and the appropriate information will be brought over. I believe it has something to do with the format of the cell but i cant work it out.

解决方案

I am trying to merge two spreadsheets together for a price update and the codes on both spreadsheets are the same but they do not register. If i type over one of the codes it then will register and the appropriate information will be brought over. I believe it has something to do with the format of the cell but i cant work it out.

How are you merging them?

How are you merging them?

I am using the v lookup and choosing the code cells for the look up

I am using the v lookup and choosing the code cells for the look up

Can you show us the code (or formula) used?

这篇关于Excel v查找的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！