AI-Powered Excel Assistant
VLOOKUP searches for a value in the first column of a range and returns a value from another column in the same row.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(A2, Products!A:C, 3, FALSE)
This searches for the value in A2 within the Products sheet and returns the price from column 3.
VLOOKUP is essential for data lookups, but consider modern alternatives like XLOOKUP for new projects.
Master the TEXT function to format numbers, dates, and times exactly how you want them displayed in Excel.
Learn to use Excel IF function for logical tests, create nested IF statements, and use modern alternatives like IFS and SWITCH.
Master conditional summing in Excel with SUMIF for single criteria and SUMIFS for multiple criteria calculations.