B
Belinda7237
I am trying to match 3 columns of data and return a value in column 4 based
on the 3 responses.
Column 1 Column 2 Column 3 Column 4
Ship New X
return a 6
Boat Old blank
returns a 4
I have a grid of responses for each scenerio in table A Rows 1-4
Almost like a vlookup but they have to meet three criteria to return the
value
and the table has every scenerio covered.
What is the best formula?
on the 3 responses.
Column 1 Column 2 Column 3 Column 4
Ship New X
return a 6
Boat Old blank
returns a 4
I have a grid of responses for each scenerio in table A Rows 1-4
Almost like a vlookup but they have to meet three criteria to return the
value
and the table has every scenerio covered.
What is the best formula?