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