Vlookup

R

rttaksali

Hi there,

I have a query in Vlookup. I have created two columns in col A which
has numbers from 11-21 and col. B Jan-Nov and is using
Vlookup(D3,Date1,1) with value with D3 as Jul it is returning #N/A. I
want to retrieve the value of the first column based on the second
col. value I enter.

Thanks for help.

Rashi
 
P

Peo Sjoblom

Look in help how vlookup works, it seems that you make 2 errors

1. You can't use VLOOKUP
2. You are not looking for an exact match

Try

=INDEX(A11:A21,MATCH(D3,Date,0))

adapt to fit to your a column range

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
Top