Hi,
I’ve tried for a while and I can’t convert the following formula to a version that uses indirect to reference a cell which contains the sheet name. In this example, I want to use F1, which contains the letters HCF.
=VLOOKUP(A2,HCF!A:D,4,FALSE)
Thanks
I’ve tried for a while and I can’t convert the following formula to a version that uses indirect to reference a cell which contains the sheet name. In this example, I want to use F1, which contains the letters HCF.
=VLOOKUP(A2,HCF!A:D,4,FALSE)
Thanks