Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Vlookup from one spreadsheet and not another
Hello,
I have a simple spread sheet (Quantities) where I'm trying to vlookup a value (ItemNumber) from another spreadsheet (ItemMaster) to return Units. The vlookup constantly returns #N/A despite the fact that I can see the ItemNumber it's supposed to be looking up. I can look up the same ItemNumber from a different spreadsheet (that holds similar info) with no problem. Any ideas on what would keep a vlookup from working on ItemMaster only? Melinda |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Vlookup from one spreadsheet and not another
Based on your description, I would guess spaces in the value you are trying
to look up (that makes it different than the itemnumber you are looking up.) You might want to try using trim. I tried the following formula and found that I needed to make it an array formula to get it to work (entered by hitting cntl-shift-enter rather than just enter.) =VLOOKUP(TRIM(K4),TRIM(H4:I5),2,FALSE) -- Kevin Vaughn "Melinda" wrote: Hello, I have a simple spread sheet (Quantities) where I'm trying to vlookup a value (ItemNumber) from another spreadsheet (ItemMaster) to return Units. The vlookup constantly returns #N/A despite the fact that I can see the ItemNumber it's supposed to be looking up. I can look up the same ItemNumber from a different spreadsheet (that holds similar info) with no problem. Any ideas on what would keep a vlookup from working on ItemMaster only? Melinda |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Vlookup from one spreadsheet and not another
Thanks that did it! I had trailing spaces in the table I was looking up
from. I trimmed out the spaces and it worked! Thanks! Melinda "Kevin Vaughn" wrote: Based on your description, I would guess spaces in the value you are trying to look up (that makes it different than the itemnumber you are looking up.) You might want to try using trim. I tried the following formula and found that I needed to make it an array formula to get it to work (entered by hitting cntl-shift-enter rather than just enter.) =VLOOKUP(TRIM(K4),TRIM(H4:I5),2,FALSE) -- Kevin Vaughn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|