R U scared of this question?

[dwarnimont]

I often use vlookup on sets of data that originate from
different sources and come with different formatting.
These are numeric & alpha-numeric part number strings.
Often the different formats will bring back N/A with
vlookup because of format. Is there a "sure" & quick way
to change/match formats to correct situation.

 

[hgrove]

(e-mail address removed) wrote...

I often use vlookup on sets of data that originate from
different sources and come with different formatting. These are
numeric & alpha-numeric part number strings. Often the
different formats will bring back N/A with vlookup because of
format. Is there a "sure" & quick way to change/match formats
to correct situation.

This has been covered before in these newsgroups. Check the Google
Groups archive.

http://www.google.com/advanced_group_search

R U 2 scared of doing your own research?

[Hint: don't use assine subject lines.]

 

[Don Guillett]

Deathly afraid.