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'!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
 
Ad

Advertisements

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'!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
 
Ad

Advertisements

L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up a returned value defining a named range 2
Return 0 instead of N/A 2
Excel Vlookup Help 0
Vlookup #N/A 5
Vlookup and #N/A 1
OR AND VLOOKUP 10
VLOOKUP Function 8
Temp variables within formulas? 2

Top