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

Savita Ubhayakar

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

Nick Korna

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!