Hiya,

I have a table where the user can insert "<10" as the column headers. The 10 is an example, the value can whatever the user wants. for example the column headers could be:

, A, B, C, D, E,
1 <6, <11, <16, <21, <26
2 (hidden row)
3 (data)

then I have a hidden row underneath, that finds the value they have entered. A2 contains:
=RIGHT($A$1,LEN($A$1)-FIND("<",$A$2))
This means row 2 will then say: 6, 11, 16, 21, 26.

I thought this would be okay to then use this hidden row as the column headers for formulas in other cells (e.g. vlookup), but it doesn't seem to work. I'm guessing that using the RIGHT formula above doesn't make it a value. In which case, is there a better function I can use to find the value entered into row 1?

Thanks
(My apologies, I couldn't think of a better thread title)