Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Formula help
Hello,
I have a formula that results with 2 rows of data spread across 9 columns. The first row contains text. The second a value. (Text Text Text Text Text... 6 5 8 16 6... ) I have a column of all possible text (19) with a column beside it that looksup the text in the first row and retrieves the value below it and MAXs' the results. My next column I wish it to Index the 2 rows to retrieve the same column 9 and return a different value 5 rows down. I have been attempting to use index, match and offset IF the rows do not equal the same column with little success. I want to know s this possible? And if so, how would I go about it? Thank you for your help, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
LOOKUP formula | Excel Worksheet Functions | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions |