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,
sathishrosario@gmail.com
Bookmarks