I have a worksheet that contains 3 columns. the columns are:
- last name
- first name
- score
i need to do a vlookup on last name AND first name, which then returns the corresponding score. the vlookup must be sure that first and last names match to differentiate between persons who may have the same last name, but different first names. i'm not sure if logical statements make sense here.
i hope THIS makes sense.
thanks in advance for your help.
