Hi all,
I need a bit of help with a formula.
I want to be able to lookup 2 values in a table and then return values if those 2 values exist in the same row and if they don't it returns "required".
I have attached an excel sheet trying to explain what I am looking for.
In tab "ToBeCreated" I want column E, "Active" to find the values if it can find the game id, game name, channel id and channel name in the tab "Existing". If they don't exist in the tab "Existing" then it returns the word "required".
Can anyone shed some light on how I could get vlookup or something of the sort to do this?
Kind regards,
Mark.
Bookmarks