Look ups

Resolved · Low Priority · Version 2016

Thu 11 Oct 2018, 09:56 Delegate Bernadette said...

Bernadette has attended:
Excel Advanced course

Look ups

What formula do I need to insert to find exact data match between two columns. Each formula I try (Vlookup or If as examples) returns an error in the formula.

I realise this is a very simple question but someone else may have an answer or solution to where I'm going wrong.

Thanks

Thu 11 Oct 2018, 10:18 Trainer Wendy said...

RE: look ups

Hi Bernadette

Thank you for using our forum

Could you send me an example of the data you're trying to match?

Also what does your formula look like? It could be a case of using absolute referencing to make sure the data selection runs correctly.

If you could, please send the file to info@stl-training.co.uk

Kind regards
Wendy Canelas
Microsoft Office Trainer

Thu 11 Oct 2018, 10:41 Delegate Bernadette said...

RE: look ups

How do I attach an excel sheet to this response?

Thu 11 Oct 2018, 10:44 Trainer Wendy said...

RE: look ups

Hi Bernadette

Please send the files to info@stl-training.co.uk

If the data is confidential, we will return them directly to you

Kind regards
Wendy Canelas
Microsoft Office Trainer

Thu 11 Oct 2018, 11:51 Trainer Wendy said...

RE: look ups

Hi Bernadette

Unfortunately, when using a VLOOKUP, the data you’re searching for has to be in the first column of your database and the columns you‘re searching have to be to the right of your search column.

The data also has to be an exact match (no excess spaces or commas or misspellings).

Looking at your file, I assume you’re trying to see if the person listed in row 2 has used the same surname on their passport for registration?

I would probably use an IF statement to check this rather than a VLOOKUP as VLOOKUP would mostly be used for finding data from another database rather than checking for matches

I have sent this back via email as well

Let me know if this helps

Kind regards
Wendy