Martin has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Formats of imported data-vlookup
Imported data is formatted in a way that vlookup cannot recognise.
The data to be looked up looks identical but the vlookup doe not recognise it.
How can this problem be dealt with
RE: Formats of imported data-vlookup
Hi Martin
Thanks for your question.
How/where is the data being imported into Excel?
thanks
Amanda
RE: Formats of imported data-vlookup
Hi amanda
The data is being imported from Oracle and WOMS through Discoverer and Monarch.
Thanks
Martin
RE: Formats of imported data-vlookup
Hi Martin
The only thing I can think of is even if the data looks the same visually it may be formatted in a different way as a result of being imported from another program. Or when the data is imported it is bringing in some additional characters which are causing the lookup not to recognise the data. Without seeing the spreadsheet I'm afraid I cannot be any more specific but these are things you could check/test to see if they are the root of your problem.
thanks
Amanda
RE: Formats of imported data-vlookup
Can I do a look up based on only part of the data in the cell?
RE: Formats of imported data-vlookup
Hi Martin
Not as far as I'm aware - what sort of thing were you thinking of?
RE: Formats of imported data-vlookup
For instance, looking up "abigail" but instead of looking for the whole word, look up middle 4 letters only!
RE: Formats of imported data-vlookup
Hi Martin
No, this wouldn't work for a vlookup - sorry :(
