If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup formula error
I am trying to lookup a value in one worksheet, find an approximate match in
another table, and return the corresponding value from the 2nd column of the lookup table. I get either #NA or #REF! Please help!?!?! |
#2
|
|||
|
|||
vlookup formula error
To prevent the #N/A allow it to happen, hide the column, and reference it
with: =IF(ISNA(A1),"",A1) #REF! means you have a dud reference. http://www.ozgrid.com/Excel/formula-errors.htm http://www.ozgrid.com/Excel/debug-formula-errors.htm -- Regards Dave Hawley www.ozgrid.com "Samantha" wrote in message ... I am trying to lookup a value in one worksheet, find an approximate match in another table, and return the corresponding value from the 2nd column of the lookup table. I get either #NA or #REF! Please help!?!?! |
#3
|
|||
|
|||
vlookup formula error
Usually when I get #REF! errors is when I don't make the lookup table wide
enough to return the column that I want -- trying to return the 3rd column from a 2 column lookup table. (Or when I break the formula by deleting one of the referred to ranges or when the table actually contains that error.) You may want to share the formula if this doesn't help. And include some sample data -- what you're trying to lookup and what's in the first column of the lookup table. Samantha wrote: I am trying to lookup a value in one worksheet, find an approximate match in another table, and return the corresponding value from the 2nd column of the lookup table. I get either #NA or #REF! Please help!?!?! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|