array formula woes

D

Debra

Greetings all,

I have found this group of such extreme value over the past 6 months
as I take the first steps in learning the wonders of excel... so thank
you to all who have offered wisdom. This, however is my first time
posting a question so forgive me if I require some feedback on the
proper way to ask a question!

I am using an array formula which reads a value in one cell then finds
the closest match to that value in a range of cells.

I use: {=INDEX($AG$5:$AG$53,MATCH(MIN(ABS($AG$5:$AG$53-AA5)),ABS($AG$5:$AG$53-AA5),0))}
works great!

Next step: I have a formula which reads the result of the above array
formula, searches a range of values to find a match and returns the
corresponding value in the column next to that match.

I use: =INDEX(AH$5:AH$53,MATCH(AC5, AG$5:AG$53,0)) works great!

My question is - can I combine these two into one or is there a better
way to accomplish this task?

Thank you so much for any help you can give.
Debra
 
F

Frank Kabel

Hi Debra
why do you want to combine them?. IMHO this is the correct
2-cell approach if you need both values returned in
separate cells. this way you only have to calculate once
the matched value from column AG.

Frank
 
Top