I would like to create a formula that will look at multiple criteria.
I will try to explain clearly.
I have a sheet 1 that i would like to validate the Rank based on a match in the name and city column and also if the value from table 1or table 2 or table 3 from Sheet1 are greater then the value in table 1or table 2 or table 3 from Sheet2. If one of the table values are greater than the sheet 2, it will result to Rank 2 value, else it will take the Rank 1 value from Sheet 2.
Ex on sheet 1:
Ex on Sheet 2:
Since on Sheet 1, Name
Robert and City
Guelf exist in Sheet 2,
then it will verify if Table 1 from sheet 1 => than Table 1 from sheet 2
Table 2 from sheet 1 = > than Table 2 from sheet 2
Table 3 from sheet 1 => than Table 3 from sheet 2.
If one of the tables are greater that the ones from Sheet2, then it will pull the value from Rank 2. It the result is <, than it will give the value from Rank 1.
If there is a not match on the name and city, it will say "No_Match
" for the rank.
An example of the result based on the 2 first images above would be:
How can i do that?
Here is a sample