Hai-anh has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Dashboards for Business Intelligence course
Influencing Skills course
Negotiating Skills course
Vlookup
Hi,
I would like to match values in second column (unique ID's) to the first column and if any come up I would Like the third column to come back with true/false
Can you help?
Thanks,
Hai-anh
RE: vlookup
Hi Hai-anh,
Thank you for the forum question.
You can use a IF function to do this. If you in column three type =If(A1=B1,True,False) and copy the function down.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: vlookup
Hi,
I would like to match the set of values in columns 1 and 2 (not as many in column 2) and if the value from column 2 is also found in column 1, the third column to come back with True/false. The column values are not in order, side by side.
Can you help?
Thanks,
Hai-anh
RE: vlookup
Hi Hai-anh,
Please have a look at the attached workbook. I am using a combination of the IF function, the ISERROR and the VLOOKUP function.
I hope this is what you want or let me know.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
compare arrays.xlsxRE: vlookup
Hi Jen,
Sorry, I couldn't see an attachment?
Thanks for your help.
Kind regards,
Hai-anh
RE: vlookup
Hi Hai-anh
You can find the attachment in my reply under my signature.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: vlookup
Hi Jen,
Thanks for this. I tried this but it didn't come out as correct as I did some spot checking.
Not sure what else you can suggest?
I want to have an exact match from the values in the second column to any exact matches to the first column. If the value from the second column cannot be found in column 1. I would like to see an #NA
Thanks,
Hai-anh
RE: vlookup
Hi Jen,
Thanks for this. I tried this but it didn't come out as correct as I did some spot checking.
Not sure what else you can suggest?
I want to have an exact match from the values in the second column to any exact matches to the first column. If the value from the second column cannot be found in column 1. I would like to see an #NA
Thanks,
Hai-anh
RE: vlookup
Hi Hai-anh,
Please find the attached workbook with an example.
I sent you the first solution because you wanted to get true/false but if you need #N/A you can just use a Vlookup.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: vlookup
Hi Jen,
Thanks for this. I can't see the attachment?
Hai-anh
RE: vlookup
Hi Hai-anh,
You should be able to see the attachment under my signature. Please when you read this press F5 sometimes you need to refresh the website to see the attachment.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
