Viewing a single comment thread. View all comments

tomistruth t1_j99qiki wrote

Reply to comment by Good-Astronomer-1138 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

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