VLOOKUP formula using the TEXT function as the "lookup value"

[RookieExcelUser808]

I have a lookup table where the lookup column is a combination of letters & numbers. I created an VLOOKUP formula that looked at the first column as all "text" values. A portion of the lookup table was as follows:

AA AB
2 97013T 122320
3 #97015T 122266
4 98003T 118449
5 99006 46128
6 99006T 122697

The original formula was VLOOKUP(A2,AA2:AB6,2,FALSE) But it appeared that when A2's value was 99006 (row 5), it would give me the N/A error. However, when I changed the formula to:
VLOOKUP(VALUE(A2,can't remember what value I put here),AA2:AB6,2,FALSE), the value 99006 would correctly return 46128.

The problem is, I can't find the old spreadsheet and I can't remember what value I used as the "Format" in the TEXT function.

 

[awoohaw]

Are you asking how to format a number as text?
If so:

=Text(yournumber,0)

if you have decimals, then:

=Text(yournumber,"#.######")