Hi All,

I have a Vlookup formula that works fine. I would like to tweak it so that
it will look up the value based on conditions. I'm not sure if this can be
done or not so any help will be appreciated.

My data is 4 columns. I am searching column A and returning column C, but
would like for the formula to look at column D and if it sees a particular
value to continue to search the rest of the data for another exact match.

I hope this makes sense to somebody. Thank you in advance for your help.

Shauna