Retrieving one cell value based on other two columns cell value

[sathishrosario]

Hi to all!!!

Herewith I am attaching the table


Column 1 Column 2 Column 3
Row 1
a c Result
Row 2
a c 1
Row 3
b d 2
Row 4
a d 5
Row 5
b c 4


-- Row 1 and Column 1 matching Cell -- and -- Row 1 and Column 2 matching Cell -- are input cells

-- Row 1 and Column 3 matching Cell -- is Result cell

My Requirement:

If I enter "a" in --Row 1 and Column 1 matching Cell -- and "c" in
-- Row 1 and Column 2 matching Cell -- means the corresponding value from Row 2 to Column 3 range cell has to display in -- Row 1 and Column 3 matching Cell --

Ex:

Row 1 and Column 1 Row 1 and Column 2 Row 1 and Column 3
Input Input Result
a c 1
a d 5
b d 2
b c 4

Your response will be highly appreciated

Thanks with Regards,
[email protected]

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.