Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Functions
I have a spreadsheet that might be something like:
Apple Banana Chips Drink 01/05 0 0 0 1 02/05 0 1 0 0 04/05 1 0 0 0 04/05 0 0 1 0 What I need to do is read the value in the top row, given a particular date (from the first column) to return the value from the top row where the intersection of the row and column is 1 I cannot get my head around the lookup functions, lookup, hlookup, vlookup etc to allow me to return the axis value given the intersection value! I hope someone can help, or at least point me in the right direction? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup / max & min functions | Excel Discussion (Misc queries) | |||
lookup functions | Excel Worksheet Functions | |||
Lookup functions | Excel Worksheet Functions | |||
LOOKUP functions? | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions |