Lookup Formula help
Please diagram a sample of the data and the desired results.
--
Thanks,
Shane Devenshire
"DavidFarnsworth" wrote:
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
|