Using a VLOOKUP and IF statement to return different values based on two different columns

Options

Hi,

I'm so sorry if this kind of question has been asked in the community forum but I've been trying to comb the questions but haven't had any true luck yet.


Currently I used a VLOOKUP function to populate a personnel contact column based on a particular project column. That part is working correctly. However, recently I needed to add in another criteria in addition to the VLOOKUP function below.


Here is what I am trying to do.

In the Contact column, if a particular study type (this is one of the columns) is ="PK" or "PKPD", then I want the contact column to populate the column using the VLOOKUP function that I already created.


However, if a particular study type is ="Formulation Check" or "Stability Assays", I want the column to bypass the VLOOKUP and just return a blank cell.


AT this point I have no idea even where to start because of the two conditions.


Is this something that is even possible? Thank you so much for any insight on this!!


Savita Ubhayakar


Tags:

Best Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Savita Ubhayakar,

    This should be possible with IF & OR functioning. If the Formulation Check/Stability Assays are the only other options then you can use this:

    =IF(OR([Study type]@row = "PKPD", [Study type]@row = "PK"), <insert your VLOOKUP formula here>, "")

    If there are more options, just use an additional IF & OR statement for the 2 others and so on.

    Hope this helps, but if you've any questions etc. then just ask!

  • Savita Ubhayakar
    Savita Ubhayakar ✭✭✭
    Answer ✓
    Options

    Hi @Nick Korna


    THANK YOU SO MUCH!! IT WORKED!! I really appreciate your help with this!! So fast! Thanks again! You all are miracle workers!!! You saved me so much time!


    Thanks again!!


    Savita Ubhayakar

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!