If/Vlookup Help?

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?


Thank you!


By: Quinn

267 thoughts on “If/Vlookup Help?

  1. Sewa Bus Pariwisata

    I simply wished to thank you therefore much again. I feel not sure the issues that I would have got gone through without the particular kind of hints revealed by simply you regarding that condition.

  2. biocan c coronavirus

    feline enteric coronavirus tropism , feline coronavirus type – complement activation contributes to severe acute respiratory syndrome coronavirus pathogenesis : when to give canine coronavirus vaccine .

Comments are closed.