Lookup function ~ weird is it possible?
I have a spreadsheet that has information listed downwards with the dates in
column A and then locations in row 1.
A B C D
1 Texas Alberta
2 Oil Aug 5 9
3 Gas Sep 12 16
4 Wind Oct 15 17
5 Solar Nov 19 19
I'd like to go to another worksheet and put in a lookup (not sure which one)
that will tell it to go out to the worksheet in the example (A1:D5) and pull
information. I'd like for it to go to the cell whose row has "Oil" and
"Texas" for a certain month.
Is this possible?
|