Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
V+HLookup?
I was wondering if there's a built in worksheet function that would allow the
lookup of row and column data. For example I have a table like this, that I want to fill in. James Kirk Hockey [cell B2] Soccer I have a data like this that I want to find the answer for: [Other.Sheet] Name Sport Score James Soccer 10 Kirk Hockey 5 James Hockey 10 Kirk Soccer 10 So in cell B2, I want to write a formula that looks in [Other.Sheet]. If "Name" matches, and "Sport" matches, then return "Score". Can this be done in Excel? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hlookup & ? | Excel Worksheet Functions | |||
Hlookup? | Excel Worksheet Functions | |||
Hlookup/max value? | Excel Worksheet Functions | |||
hlookup #N/A | Excel Worksheet Functions | |||
HLookup ??? | Excel Discussion (Misc queries) |