Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |