Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird recalculation of user defined function | Excel Worksheet Functions | |||
weird problem with LOOKUP function | Excel Discussion (Misc queries) | |||
weird problem with LOOKUP function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
This is Weird - Dead Simple Issue with Sum Function | Excel Worksheet Functions |