Vllookup(Text

[jamphan]

I am trying to do a vlookup formula that converts my lookup field to text. What is the correct syntax for that?

[NBVC]

Can you give samples of what your lookup field may look like?

Does it have to be converted throught a formula or can it be converted with Excel tools?

[Mark@Work]

Essentially the answer is =VLOOKUP(TEXT(A1,"#"),E1:G18,2)
where A1 is the value you want to match in cells E1 to E18
returning the value in the second column of the range E1 to G18
(ie from cells F1 to F18)
The text converts the number in cell A1 into a text representation of that number.
In this case into an INTEGER representation!
The "#" sets the conversion format in the same way as the custom formats used to set the way cells display the values in them.
The trouble with this is that you must ensure that the lookup value is EXACTLY identical to the value you are trying to match.
This means that the format you choose in the TEXT instriction is critical.
If you could expand your description of your problem we might be able to be more precise in our response.