Excel VLOOKUP mix of text and numbers

Hi Stephen,

Index + Match versus Vlookup.

You can do it with a Vlookup but Index + Match is a much better solution. Worst case the Index + Match is faster for Excel to handle. Best case Index + Match is extremely faster and use less of your pc's memory.

The structure:

Tab1!B1=Index(Tab2!$B$1:&B$4,Match(Tab1!A1,Tab2!$A$1:$A$4,0))

The Index function needs first the range, where you have the data you will like to return to the select cell. The Index function then needs the row number. The Match function returns the row number to the Index function

I hope this make sense.




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

Hi Stephen,


I guess you are using a laptop.

You will have to press FN F4 or change your laptop to use the F keys.

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