excel consulting - formats imported datavlookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consulting - Formats of imported data-vlookup

excel consulting - Formats of imported data-vlookup

resolvedResolved · Low Priority · Version Standard

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 :(

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips


Server loaded in 0.1 secs.