vlookup issue - should be simple ... but....

[cuslyguy]

I'm missing something here.... Ive done similar things multiple times, but its not working for me today.

=vlookup(B1,$D$1:$P$26,1,FALSE)

that's my formula

and here is an example of my setup:

B D E F G H I J
11/01/2014 1 27 11/01/2014 11/02/2014 11/03/2014 11/04/2014 11/05/2014
12/03/2014 2 28 12/01/2014 12/02/2014 12/03/2014 12/04/2014 12/05/2014

So I am expecting my vlookup to search the array and when it finds a match to the record that I have listed, to return whatever is in the first column of my array.

But all it returns is the standard #N/A ....

Any thoughts? Thanks guys

 

[bbott]

VLOOKUP only searches the left most column for your search value, not the entire array. If you're trying to find a match in the D1:P26 array and return the first column, you would need to use INDEX/MATCH.

 

[cuslyguy]

thank you much!

 

[bbott]

thank you much!

You're welcome.

 

[JazzSP8]

Hi

VLOOKUP will only look in column D for the value you in B1

It won't look in all the cells in the range

You need to reorganise your data so all the dates are in one column for that to work

You're possibly looking at reorganising your data into two columns or using a MATCH / INDEX combination.

HTH

 

[JazzSP8]

Ha. No replies when I clicked 'reply' - 3 by the time I'd finished... :/

Sorry about that!