=XLOOKUP(G2,A2:A5,D2:D5)
=XLOOKUP(G2,A2:A5,D2:D5)
Practice Excel by solving realistic business problems using formulas, functions, data analysis, and spreadsheet-based decision making.
Work through practical business scenarios and build job-ready skills step by step.
Login as Student to EnrollFocus on the skills and techniques covered throughout this program.
Practice with realistic business problems designed to develop practical, job-ready skills.
=XLOOKUP(G2,A2:A5,D2:D5)
Now suppose the same information is maintained vertically:
EX-03
EX-04
EX-05
EX-06
EX-07
EX-08
EX-09
ROWS() returns the number of rows in a specified range.