Hey i am wondering if you can use vlookup to validate criteria in either 1 of 2 columns.
IE:
Cell A1 has the serch critera i want to validate that this content is in either column B or D then return the value in column C if it is in EITER column B or D.
Is vlookup capable of doing this or will i have to use match with an aray?
IE:
Cell A1 has the serch critera i want to validate that this content is in either column B or D then return the value in column C if it is in EITER column B or D.
Is vlookup capable of doing this or will i have to use match with an aray?