Is it possible to Nest Index Match Statements?

[Dave_P_C]

Hi all,

I am working through a spreadsheet converting multiple VLOOKUP statements to IndexMatch equivalients but have found one I can not work out.

This VLOOKUP statement has a nested VLOOKUP statement that returns the value which needs to be looked up.

=VLOOKUP(VLOOKUP(G$124,$D$78:$E$94,2,FALSE),$C$41:$J$59,2,FALSE)

Below I've changed the cell ranges to named ranges for easier reference

I can split this into 2 separate index match statements in different cells with the first one returning the lookup value required for the second

1. Entered in cell B82

[TABLE="width: 515"]
<tbody>[TR]
[TD="width: 515"]=INDEX(Table1[Column1],MATCH($G$124,Table1[Column2],0))[/TD]
[/TR]
</tbody>[/TABLE]

2.

=INDEX(Table2[Column2],MATCH($B$82,Table2[Column1],0))

Can this be converted to a single IndexMatch statement?

Thanks for looking,
Dave.

 

[dreid1011]

Have you tried to combine it yet?

=INDEX(Table2[Column2],MATCH(INDEX(Table1[Column1],MATCH($G$124,Table1[Column2],0)),Table2[Column1],0))

 

[Dave_P_C]

@dreid1011 - Thank You

I had tried combining the statements but must have messed up the syntax and after hours of trying had not manged to get them to work.

Due to your post this now works so I appreciate your reply.

 

[dreid1011]

You're welcome. Happy to help.