Lookup with variable name

[J]

I have one sheet with a bunch of named fields on it which I use for
lookups.
I have oAOne, oBOne, oATwo, oBTwo. I'd like to get the lookup string
from multiple cells. Something like, =HLOOKUP(C18,c2 & c3 & Two,2,1).
This doesn't work. I don't know if it's a syntax problem or something
that is just not possible.


Thanks

 

[Frank Kabel]

Hi
try
=HLOOKUP(C18,INDIRECT(c2 & c3 & Two),2,1)