Data Type Problem

  • Thread starter Thread starter robbyp
  • Start date Start date
R

robbyp

I have been searching for a long time to find an answer to this and nothing
has come up yet.....

I have a column of data that consists of both numeric and text values. On a
separate worksheet I have data that is all text. I am doing a vlookup to
bring in values to the first worksheet for data. I get a lot of #N/A values
when I do this for one reason:

The numeric data type value will not lookup its equivalent as a text data
type value. Even when I change the numeric data type to text, nothing
happens......until I double-click the cell and then click off of it. It THEN
seems to become text and the #N/A changes to the accurate lookup value.

I've tried everything to find a quick way to get this to work as it's a real
pain to double-click each cell and then click off for the vlookup to work. I
would really appreciate some help. Thanks.
 
Say your datalist is A1 to B10, with *text* numbers in a1 to A10.

If your Vlookup formula is say:

=Vlookup(3,A1:B10,2,0)

You can use:
=Vlookup("3",A1:B10,2,0)

If your Vlookup formula is:

=VLOOKUP(D1,A1:B10,2,0)

You can use:
=VLOOKUP(TEXT(D1,"#"),A1:B10,2,0)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have been searching for a long time to find an answer to this and nothing
has come up yet.....

I have a column of data that consists of both numeric and text values. On a
separate worksheet I have data that is all text. I am doing a vlookup to
bring in values to the first worksheet for data. I get a lot of #N/A values
when I do this for one reason:

The numeric data type value will not lookup its equivalent as a text data
type value. Even when I change the numeric data type to text, nothing
happens......until I double-click the cell and then click off of it. It THEN
seems to become text and the #N/A changes to the accurate lookup value.

I've tried everything to find a quick way to get this to work as it's a real
pain to double-click each cell and then click off for the vlookup to work. I
would really appreciate some help. Thanks.
 
Back
Top