Lookup

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a spreadsheet similiar to the following;

A B C D
1 JAN FEB MAR
2 expense 10.00 15.00 8.00

In a second spreadsheet i would like to be able type the
month in one cell(A1) and have the vlookup(A2) read the
info in (A1) and show the corresponding expense from the
first spreadsheet.

Thank you

Mike
 
Try using Hlookup. In your example, the data item you are
looking for resides BELOW the header as opposed to the
right. The Hlookup should work for you in this case. In
your example below the formula(assuming you typed JAN in
cell A1 on your other sheet) should be: =Hlookup(a1,sheet2!
1:2,2,0). This should return the value you are looking for.
Good Luck!!
 
Back
Top