# VLOOKUP returning #N/A result

L

#### 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

C

#### 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
Try:
=VLOOKUP(TRIM(A4),'Worksheet Name'!B1500,2,0)

Regards
Claus Busch

L

Hi Clause,