SS Lookup
VLOOKUP
Vertical LookupVLOOKUP
To pull in data from other sheets based on a "key" field (perhaps to create some sort of summary sheet) we can use something like this...
=IFERROR(VLOOKUP(A15, Sheet1!$A$1:$D$84, 3, FALSE),0)
The IFERROR enables us to return 0 if the lookup failsIn this example cell A15 on our current sheet holds the key to lookup on Sheet1Using $ symbold in front of the range of cells to scan makes it possible to drag the formula up/down in order to easily do lookups on multiple values.The range must include the cells likely to hold the key field and the cells likely to hold the return valueIn our example the 3 defines that the cell in the 3rd column on the same rows as the lookup key will be returned.FALSE specifies that an error is returned if the lookup would return more than one result.HLOOKUP
Horizontal LookupHLOOKUP
XLOOKUP
XLOOKUP
INDEX & MATCH
INDEX & MATCH
Bibliography
Bibliography
VLOOKUPhttps://support.microsoft.com/en-au/office/video-vlookup-when-and-how-to-use-it-9a86157a-5542-4148-a536-724823014785https://www.solveyourtech.com/display-0-instead-na-using-vlookup-excel-2013/https://www.ablebits.com/office-addins-blog/2020/02/12/vlookup-multiple-sheets-excel-examples/https://www.extendoffice.com/excel/functions/excel-vlookup-function.htmlhttps://www.indeed.com/career-advice/career-development/vlookup-multiple-valueshttps://www.ablebits.com/office-addins-blog/if-vlookup-excel/
QUERYhttps://stackoverflow.com/questions/16256388/recreating-a-google-spreadsheets-query-in-excel
QUERYhttps://stackoverflow.com/questions/16256388/recreating-a-google-spreadsheets-query-in-excel
https://support.microsoft.com/en-gb/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f
https://support.microsoft.com/en-gb/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929