#### alivein2025

##### New Member

Should I use INDEX-MATCH instead of VLOOKUP?

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter alivein2025
- Start date

Should I use INDEX-MATCH instead of VLOOKUP?

I liked index/match as you did not need to work out the column with numbers and also (although possible in vlookup) you could return values to the left of the lookup column

I still tend to use index.match even now even though had 365 and xlookup for some time

your call

Thank you! Very helpful.

Thank you so much!

I liked index/match as you did not need to work out the column with numbers and also (although possible in vlookup) you could return values to the left of the lookup column

I still tend to use index.match even now even though had 365 and xlookup for some time

your call