Viewing a single comment thread. View all comments

textris t1_j98qeoo wrote

Reply to comment by jj-reeder in LPT: Take a few days to familiarize yourself with a spreadsheet app (e.g., MS Excel, Google Sheets). The uses are endless for school, the office, life, and other people will think you're a wizard. by tophswanson

INDEX MATCH ftw!

78

Good-Astronomer-1138 t1_j98y572 wrote

This has been replaced by XLOOKUP now

68

tomistruth t1_j99qiki wrote

Example code for people who rarely work in excel?

8

thequicknessinc t1_j9a4cj1 wrote

=XLOOKUP(value to look up,range/array to lookup value in, range/array to return)

16

tomistruth t1_j9a60l0 wrote

Thx! Noted.

5

Good-Astronomer-1138 t1_j9a8hqd wrote

You can also denote a value for blanks and select a search order at the end : so like xlookup(value, search range, return range, “”, 1) would default all blanks to blank and sort in the default way

3

PatrickKieliszek t1_j98xyao wrote

Index Match is good if your data set is large and you're worried about execution time.

For small data I almost exclusively use xlookup.

14

geekgodzeus t1_j99h77s wrote

I recently started using SUMIFS and it has been a godsend .

9