Posted to microsoft.public.excel.worksheet.functions
|
|
Reverse Index and Match Functions
Thank you Max and Harlan!!!!
"Max" wrote:
Karl, my sincere apologies,
As Harlan stated correctly in his posting, I had mis-read your original
posting and suggested the wrong formula.
The correct 1st formula for your original posting should have been:
=INDEX($A$1:$A$4,MATCH(G1,OFFSET($A$1:$A$4,,MATCH( F1,$A$1:$D$1,0)-1,),0))
where inputs
in G1: 6 (internal value within B2:D4)
in F1: 2 (value in 1st row vertically above the internal value in G1)
And the corrected adaptation for your "actual situation"
should read something like this:
=INDEX($A$100:$A$400,MATCH(G1,OFFSET($A$100:$A$400 ,,MATCH(F1,$A$100:$X$100,0)-1,),0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|