| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2-Dim Lookup
Hi,
I've been using VLookup and it works well. But now I'd like Excel to choose the cell that matches both the vertical and horizontal indexes. IE I'd like it to choose the formula or value that is, say, below the value 3 (HLookup) AND to the right of value 51 (as VLookup). Can anyone help me? Thanks in advance. Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
| How to lookup data in a row and column | Excel Discussion (Misc queries) | |||
| need check two worksheets to lookup a value | Excel Discussion (Misc queries) | |||
| Another Lookup function, please | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
