Lookup with variable name

  • Thread starter Thread starter J
  • Start date Start date
J

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
 
Back
Top