VLOOKUP, why #N/A
 

I am trying to figure why I am getting #N/A. My function is coded as:
=VLOOKUP(A28465,W9038352AY.xls!$A$1:$E$5,W9038352A Y.xls!$E$1,0).

I can actually see the contents of cell A28465 of the base ss in A1 of
W9038352AY.xls and they are both formatted as number. I have tried changeing
the format to text and general to no avail.

My intent is to put the contents of E1 in column D of the base ss whenever
col A of the base ss is equal to col A of W9038352AY.xls

VLOOKUP, why #N/A
 

Your formula should be

=VLOOKUP(A28465,W9038352AY.xls!$A$1:$E$5,5,FALSE).

You need to enter how many columns across the lookup table the value you
want to return is positioned.

Andrea Jones
www.stratatraining.co.uk

"GKW in GA" wrote:

I am trying to figure why I am getting #N/A. My function is coded as:
=VLOOKUP(A28465,W9038352AY.xls!$A$1:$E$5,W9038352A Y.xls!$E$1,0).

I can actually see the contents of cell A28465 of the base ss in A1 of
W9038352AY.xls and they are both formatted as number. I have tried changeing
the format to text and general to no avail.

My intent is to put the contents of E1 in column D of the base ss whenever
col A of the base ss is equal to col A of W9038352AY.xls

VLOOKUP, why #N/A
 

Is w9038352ay.xls a worksheet in the same workbook or is it a different
workbook?

If it's a different workbook, then why aren't there any []'s and worksheet name
in that formula?

If it's a worksheet in the same workbook, then I'd review the notes for
troubleshooting =vlookup() formulas from Debra Dalgleish:

http://contextures.com/xlFunctions02.html#Trouble

====
Changing the format of the cell won't change the underlying value. If you
reformat the cell, then reenter the value and then check your formula.

GKW in GA wrote:

I am trying to figure why I am getting #N/A. My function is coded as:
=VLOOKUP(A28465,W9038352AY.xls!$A$1:$E$5,W9038352A Y.xls!$E$1,0).

I can actually see the contents of cell A28465 of the base ss in A1 of
W9038352AY.xls and they are both formatted as number. I have tried changeing
the format to text and general to no avail.

My intent is to put the contents of E1 in column D of the base ss whenever
col A of the base ss is equal to col A of W9038352AY.xls

--

Dave Peterson