VLOOKUP or INDEX+MATCH?

A

amalCSCC

New Member
Joined
Nov 24, 2023
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello all,
I have been trying to look for the right formula between VLOOKUP and INDEX+MATCH; When should I use each function?
Can you please help?
Thanks,
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Hi and welcome to MrExcel

With version 365, the best option is XLOOKUP


XLOOKUP function - Microsoft Support

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...
support.microsoft.com support.microsoft.com
 
Upvote 1
Solution
DanteAmor said:
Hi and welcome to MrExcel

With version 365, the best option is XLOOKUP


XLOOKUP function - Microsoft Support

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...
support.microsoft.com support.microsoft.com
Click to expand...
Thank you for your answer!
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Using Vlookup or Index/Match across 2 workbooks
Replies
1
Views
196
DataKnight
D
C
  • Question
Index Match question
Replies
2
Views
80
Cubist
Cubist
A
  • Question
Index and Match for 2No criteria only partially returning values other values #ref error.
Replies
6
Views
138
roelandwatteeuw
R
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69
M
  • Solved
INDEX AND MATCH #REF ERROR
Replies
9
Views
268
awoohaw
awoohaw

Forum statistics

Threads
1,215,069
Messages
6,122,954
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top