Embed/Nest Three functions.

[Ben Morton]

Hi there,

I've already nested INDEX and MATCH sucesfully

I wish to embed/nest (I'm not sure what the difference/ correct syntax is)

These Funtions:

1. "=INDEX($H$4:$H$9,MATCH(G14,$G$4:$G$9,0))"

2, =HLOOKUP(Arg!D10,Arg!$D$10:$DA$50,5,FALSE)


The HLOOKUP returns a text value that the Index and Match convert into a number. I wish this to be done in one cell - is this possible?


I'm using INDEX with MATCH because HLOOKUP can return a 'not applicable' that equals '6' this need to be discounted in my results but that is a digression FYI.


Thanks for any ideas.

Ben

[martindwilson]

i presume the h look up is in g14
=INDEX($H$4:$H$9,MATCH(HLOOKUP(Arg!D10,Arg!$D$10:$DA$50,5,FALSE)
,$G$4:$G$9,0))

[Ben Morton]

Thanks Martin,

That's Perfect.

Regards,


Ben