George Arakelian
New Member
I want to find a formula that extracts a value corresponding two two columns if the values in those two columns match exactly those in another set of two columns. Please, see an example in the attached document.
If the values of two columns match, extract the corresponding value
- Thread starter George Arakelian
- Start date
Somendra Misra
Excel Ninja
Hi George,
Try Below array formula in E3 and copy down:
=IFERROR(INDEX($J$3:$J$6,MATCH(C3&D3,$H$3:$H$6&$I$3:$I$6,0)),"")
Note: 1. Must be entered with Ctrl+Shift+Enter, and not just Enter.
2. Only work if you data set has no duplicates of column H & I. If you have duplicates than formula need to change.
Regards,
Try Below array formula in E3 and copy down:
=IFERROR(INDEX($J$3:$J$6,MATCH(C3&D3,$H$3:$H$6&$I$3:$I$6,0)),"")
Note: 1. Must be entered with Ctrl+Shift+Enter, and not just Enter.
2. Only work if you data set has no duplicates of column H & I. If you have duplicates than formula need to change.
Regards,
George Arakelian
New Member
The formula gave me the wrong results. Please take a look at the attached file
Faseeh
Excel Ninja
@George Arakelian
In worksheet formula the last argument of Match() should be zero as in the post, but is actually missing. Please put in this formula form @Somendra Misra's Post:
The Zero in Red is missing from the sheet.
In worksheet formula the last argument of Match() should be zero as in the post, but is actually missing. Please put in this formula form @Somendra Misra's Post:
The Zero in Red is missing from the sheet.
George Arakelian
New Member
wonderful, it worked. Thank you Faseeh