[PDF]EXCEL Formulas Face Off

XA] Excel Formulas Face-Off:


VLOOKUP
XLOOKUP
HLOOKUP and
INDEX-MATCH


i ma cs me lm, Sm rem, Sm tt a.m a |


(1) VLOOKUP


A classic formula that searches for a specific value in the


first column of a range and returns a corresponding value
from another column.


Example: Looking up an emplovee's salarv based on their emplovee ID.


ZVLOOKUP(emplovee id, emplovee data, salarv. column, FALSE)


(2) XLOOKUP (Excel 365 & Excel 2019)


A versatile and user-friendiv function that simplifies the


lookup process, addressing VLOOKUP and HLOOKUP
limitations.


Example: Finding the product price based on its name.


-XLOOKUP(product name, product names range, product prices range)


(3) HLOOKUP


Like VLOOKUP, it searches for a value in the first row of a
table and returns a value from the same column in
another row.


Example: Retrieving a monthiv sales target from a table with months in the top row.


=HLOOKUP(month, sales data, target row, FALSE)


(4) INDEX-MATCH


A powerful combination of two Excel functions, INDEX


and MATCH, which provides flexibility and enhanced
performance.


Example: Determining a customer's region based on their customer number.


=INDEX(regions_range, MATCH(customer_number, customer_numbers_range, 0))