vlookup to convert to match and index vba

Hi All,

Can i check how could i change the below formula function to a match and index function instead. The reason is i understand that vlookup needs to take the left most column for reference. I do know how to place the match and index function as a formula in a cell. Need some help to understand which to amend for VBA though.


I would like to move the column reference on the database sheet to column D and E.

Vlookup VBA

Please Login or Register  to view this content.

Thank you BSB. It was perfect.

Happy to help

BSB