Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP returning #N/A result
Can anyone possibly help with the following?
I have the formula below which keeps returning #N/A VLOOKUP(TRIM($A4),’Worksheet Name'!A261:D261,3,FALSE) Where the value to be found in the Range is in B261 (column 2) and the value I want returned is in C261 (column 3) which is the letter “R”. When I evaluate the formula using F9 I get the following: =VLOOKUP("5-C60-0019"),{0,"5-C60-0019","R",0},3,FALSE) I am only checking row 261 as I know the number exists in my table and the formula should work and then I will use it across the whole table range. I am so close to getting this to work. Can anyone advise on why this curled arrow evaluation is happening? {0,"5-C60-0019","R",0} and if this is the cause of my formula not working. Thanks in advance for any input! LCTECH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP returning #N/A result
Hi,
Am Tue, 21 Aug 2012 00:34:22 -0700 (PDT) schrieb LCTECH001: Can anyone possibly help with the following? I have the formula below which keeps returning #N/A VLOOKUP(TRIM($A4),?Worksheet Name'!A261:D261,3,FALSE) Where the value to be found in the Range is in B261 (column 2) and the value I want returned is in C261 (column 3) which is the letter ?R?. if the value to be found, is in column B then Column B has to be the first column in your array. Try: =VLOOKUP(TRIM(A4),'Worksheet Name'!B1:D500,2,0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP returning #N/A result
Hi Clause,
Thank you so much for your answer it has worked!! I am so relieved as I had a very long day of manually checking codes ahead of me if I couldn't get my formula to work! Thanks again, much appreciated LCTECH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning the result of a vlookup in the same cell | Excel Worksheet Functions | |||
Vlookup returning more than one result | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
vlookup returning a n/a result | Excel Worksheet Functions | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) |