I have a column of numbers and text that I am trying to use in a vlookup
formula. Rather than go thru the numbers and add a ' at the front to format
as text, is there a simple fix that I can employ to change these 500 or so
numbers.....

Gets redundant....

The easiest way is to convert them in the vlookup, to lookup a number against
text put a & "" after the lookup value like this
=VLOOKUP(A1&"",C1:J36,1,0)

if zeroes in front are messing you up then you can convert them to text with
=Text(A1,"0000")

And i think i confused myself about which one you are looking up against
which, so this formula looks up text against a list of numbers

=VLOOKUP(--A1,C1:J36,1,0)


--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Tom" wrote:

I have a column of numbers and text that I am trying to use in a vlookup
formula. Rather than go thru the numbers and add a ' at the front to format
as text, is there a simple fix that I can employ to change these 500 or so
numbers.....

Gets redundant....

Thanx John

I also found a work around using the text to columns feature on only the
"Numbers".

"John Bundy" wrote:

The easiest way is to convert them in the vlookup, to lookup a number against
text put a & "" after the lookup value like this
=VLOOKUP(A1&"",C1:J36,1,0)

if zeroes in front are messing you up then you can convert them to text with
=Text(A1,"0000")

And i think i confused myself about which one you are looking up against
which, so this formula looks up text against a list of numbers

=VLOOKUP(--A1,C1:J36,1,0)


--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Tom" wrote:

I have a column of numbers and text that I am trying to use in a vlookup
formula. Rather than go thru the numbers and add a ' at the front to format
as text, is there a simple fix that I can employ to change these 500 or so
numbers.....

Gets redundant....