Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Across Multiple Rows / Columns
hey
I need to look up a value from an group of cells across rows and sheets, and return the top and left hand value from the location of the result. Eg: One Two Three Four Left a b c d Right e f g h Up i j k l Down m n o p If I searched for 'f', I need to return 'Two Right'. 'p' should return 'Four Down' I have tried various match and index formulas with no success. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup value across multiple columns and rows | Excel Worksheet Functions | |||
lookup to multiple rows and columns | Excel Worksheet Functions | |||
Using lookup function on multiple rows and columns | Excel Worksheet Functions | |||
Find a value Using a lookup table multiple columns and rows | Excel Worksheet Functions | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions |