Lookup returns text?

R

rydolarue

Is there a function similar to SUMIF for numerical data that will retur
text?

I have a list of item #'s that have no description. I want to be abl
to lookup the item # and return the description from a master list.

Any ideas?

TEXTIF would be great, but that doesn't exist that I'm aware of.

Thanks,
Rya
 
R

rydolarue

I have tried the vlookup function, but that doesn't return the correc
text value.

Could the formatting of the item #'s, which is used as the looku
value, be causing the problem
 
R

rydolarue

Problem solved!

It seems that all the item #'s in our accounting software are/wer
entered as text, not numerical values. I simply converted to #'s an
the VLOOKUP worked as it should.

Thanks again,
Rya
 
Top