Hello:

In one tab of a spreadsheet, I have two columns. Column A contains my
VLOOKUP formula. Column B contains Inventory item numbers. This tab is
called "Sales".

The other tab of my spreadsheet is called "Items". This tab, also, contains
two columns. Column A contains item numbers found within column B of the
"Sales" tab.

Column B of the "Items" tab contains the former names of these item numbers
(the prior-used names).

I want the VLOOKUP of the "Sales" tab to place into column A of the "Sales"
tab the item numbers of column B of the "Items" tab. The formula that I have
in column A of the "Sales" tab is not working:
=VLOOKUP(B2,Items!$A$2:$B$220,2,FALSE)

How can I fix this?

Thanks!

childofthe1980s

You ddin't say what error you were getting. If you are not getting an error
then the data doesn't EXACTLY match. This is usually because there is extra
spaces in the data or one cell contains more data than the other.

"childofthe1980s" wrote:

Hello:

In one tab of a spreadsheet, I have two columns. Column A contains my
VLOOKUP formula. Column B contains Inventory item numbers. This tab is
called "Sales".

The other tab of my spreadsheet is called "Items". This tab, also, contains
two columns. Column A contains item numbers found within column B of the
"Sales" tab.

Column B of the "Items" tab contains the former names of these item numbers
(the prior-used names).

I want the VLOOKUP of the "Sales" tab to place into column A of the "Sales"
tab the item numbers of column B of the "Items" tab. The formula that I have
in column A of the "Sales" tab is not working:
=VLOOKUP(B2,Items!$A$2:$B$220,2,FALSE)

How can I fix this?

Thanks!

childofthe1980s

Please re-read what I said. Instead of returning column B of "Items", it is
returning "N/A".

"Joel" wrote:

You ddin't say what error you were getting. If you are not getting an error
then the data doesn't EXACTLY match. This is usually because there is extra
spaces in the data or one cell contains more data than the other.

"childofthe1980s" wrote:

Hello:

In one tab of a spreadsheet, I have two columns. Column A contains my
VLOOKUP formula. Column B contains Inventory item numbers. This tab is
called "Sales".

The other tab of my spreadsheet is called "Items". This tab, also, contains
two columns. Column A contains item numbers found within column B of the
"Sales" tab.

Column B of the "Items" tab contains the former names of these item numbers
(the prior-used names).

I want the VLOOKUP of the "Sales" tab to place into column A of the "Sales"
tab the item numbers of column B of the "Items" tab. The formula that I have
in column A of the "Sales" tab is not working:
=VLOOKUP(B2,Items!$A$2:$B$220,2,FALSE)

How can I fix this?

Thanks!

childofthe1980s

The VLOOKUP help says the following

1) If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.
2) If lookup_value is smaller than the smallest value in the first column of
table_array, VLOOKUP returns the #N/A error value.
3) If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP
returns the #N/A value.


"childofthe1980s" wrote:

Please re-read what I said. Instead of returning column B of "Items", it is
returning "N/A".

"Joel" wrote:

You ddin't say what error you were getting. If you are not getting an error
then the data doesn't EXACTLY match. This is usually because there is extra
spaces in the data or one cell contains more data than the other.

"childofthe1980s" wrote:

Hello:

In one tab of a spreadsheet, I have two columns. Column A contains my
VLOOKUP formula. Column B contains Inventory item numbers. This tab is
called "Sales".

The other tab of my spreadsheet is called "Items". This tab, also, contains
two columns. Column A contains item numbers found within column B of the
"Sales" tab.

Column B of the "Items" tab contains the former names of these item numbers
(the prior-used names).

I want the VLOOKUP of the "Sales" tab to place into column A of the "Sales"
tab the item numbers of column B of the "Items" tab. The formula that I have
in column A of the "Sales" tab is not working:
=VLOOKUP(B2,Items!$A$2:$B$220,2,FALSE)

How can I fix this?

Thanks!

childofthe1980s

Thank you so much, Joel!!!

#3 of what you said resolved it! I had to change it from FALSE to TRUE!

Again, thanks!

childofthe1980s

"Joel" wrote:

The VLOOKUP help says the following

1) If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.
2) If lookup_value is smaller than the smallest value in the first column of
table_array, VLOOKUP returns the #N/A error value.
3) If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP
returns the #N/A value.


"childofthe1980s" wrote:

Please re-read what I said. Instead of returning column B of "Items", it is
returning "N/A".

"Joel" wrote:

You ddin't say what error you were getting. If you are not getting an error
then the data doesn't EXACTLY match. This is usually because there is extra
spaces in the data or one cell contains more data than the other.

"childofthe1980s" wrote:

Hello:

In one tab of a spreadsheet, I have two columns. Column A contains my
VLOOKUP formula. Column B contains Inventory item numbers. This tab is
called "Sales".

The other tab of my spreadsheet is called "Items". This tab, also, contains
two columns. Column A contains item numbers found within column B of the
"Sales" tab.

Column B of the "Items" tab contains the former names of these item numbers
(the prior-used names).

I want the VLOOKUP of the "Sales" tab to place into column A of the "Sales"
tab the item numbers of column B of the "Items" tab. The formula that I have
in column A of the "Sales" tab is not working:
=VLOOKUP(B2,Items!$A$2:$B$220,2,FALSE)

How can I fix this?

Thanks!

childofthe1980s