Amy has attended:
Excel Advanced course
Word Advanced course
PowerPoint Intermediate Advanced course
VLookup
Good Afternoon,
I would like to produce a VLOOKUP using names which are in two separate columns (first name and surname) and then source my findings using names in the same format . Currently I am using the CONCENTRATE formula to combine the first name and surname in the information I am using to source and the information sourced but I wasn’t sure if this was the most effective way of producing the look up?
I would be grateful for any tips.
RE: VLookup
Hi Amy
Thanks for getting in touch. This sounds like a very sensible approach, by concatenating the names you can look them up in one formula.
Did you know you can substitute the CONCATENATE formula with the & symbol? If your formula is
=CONCATENATE(A1," ",B1)
This can also be written as
=A1&" "&B1
So in a VLOOKUP you could say
=VLOOKUP(A1&" "B1,C3:E55,3)
or something similar.
I hope this helps.
Kind regards
Gary Fenn
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
