Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following:
- There could be 2 rows of data for the same person, but contains different numerical values that I need to pull.
- For example… if C2 says “bonus 1” then return the value in this field, otherwise, return zero.
I’m basically going to have 2 rows of data for the same person, where one row has bonus 1 of $1000 and the second row has bonus 2 for $3000. Since vlookups only pull the first row it finds (and will duplicate the same value after that), I was hoping there is some other way to go about achieving this?