I'm sure there is a function in excel to do what I want to do, I just don't
know what that is. I was hoping you could help me. I have a table set up
for daily fuel prices on sheet 1. Column A is the date, Columns B-I are
different locations. (Row 1 is my headings, data is compiled in rows 2-100).
On sheet two, I've entered a date in Col.A, and the heading "Location" in
Col.B where I type a location that matches the headings on Sheet 1, Col.B-I.
In Col.C, Sheet 2, I want a lookup function of some sort to return the value
from the cell that intersects the date/location from sheet 1. I've tried
several things, including embedding vlookup in hlookup but that just keeps
sending me around in circles. I know this can be done. Could you please
tell me how to do it?
Thanks!
Loni

Loni