Help with this layered function....

Originally Posted by tortuga0981

Why won't this function work?

=CELL("contents",VLOOKUP((MATCH(1,B1:AS1,0)-2),ALPHA,2))

I am simply embedding the function =VLOOKUP((MATCH(1,B1:AS1,0)-2),ALPHA,2) into the CELL function in order to retreive the contents of the cell V2 (which in fact the function VLOOKUP will return by itself). But for some reason when embedded into the CELL function it won't work?

Any thoughts? Thanks in advance.

Hi,

I think you need to 'Indirect' that with

=CELL("contents",INDIRECT(VLookup

etc, providing the Lookup returns a valid address.

hth
---

Originally Posted by tortuga0981

Thank you god I can now sleep!

Hi,

I don't think she comes to this forum often, but I take it that worked for you.

Cheers