Scribd
Upload
41 views21 pages

Excel Grade Lookup Guide

This document contains a table with students' first names, last names, and grades. It also contains a formula to look up a student's grade based on their full name by combining VLOOKUP with an IF statement to handle duplicate names, and returning the grade from the correct row. The formula uses INDEX and MATCH to return the correct row for lookup instead of a hardcoded row number.

Uploaded by

Omar Santamaría Castillo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
41 views21 pages

Excel Grade Lookup Guide

This document contains a table with students' first names, last names, and grades. It also contains a formula to look up a student's grade based on their full name by combining VLOOKUP with an IF statement to handle duplicate names, and returning the grade from the correct row. The formula uses INDEX and MATCH to return the correct row for lookup instead of a hardcoded row number.

Uploaded by

Omar Santamaría Castillo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

First_Name Last_Name Grade Name Surname Grade

Jim Brown A Jim Brown A


Billy Jean A Sarah Jones B
Sarah Jones B Billy Ray C
Billy Ray C Billy Jean A

2
1
0 In these two columns Find these two names

3
Return the Grade in column C

=VLOOKUP(E2&F2,IF({1,0},First_Name&Last_Name,Grade),2,FALSE)

1 2 3

Value if FALSE or 0

IF({1,0},First_Name&Last_Name,Grade)

Value if TRUE or 1
INDEX & MATCH
A
B
C
A

You might also like