Ravi Sir's Cards › Excel
XLOOKUP: first match, last match, not found
Revision card: XLOOKUP: first match, last match, not found. Example data table with Raja's last entry: ₹520; Raja's first entry: ₹300; A name not in A2:A4: Not found.
Read card text
What this card says
XLOOKUP: first match, last match, not found
Example
data table with Raja's last entry: ₹520; Raja's first entry: ₹300; A name not in A2:A4: Not found
Learn this in the lesson: Excel XLOOKUP Tutorial: Search Right to Left, Last Match, Not Found Message and Drop-Down List