VLOOKUP returning #N/A result

[LCTECH001]

Can anyone possibly help with the following?
I have the formula below which keeps returning #N/A

VLOOKUP(TRIM($A4),’Worksheet Name'!A261261,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

 

[Claus Busch]

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'!A261261,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'!B1500,2,0)


Regards
Claus Busch

 

[LCTECH001]

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