Forum Discussion
Solved
Need FORMULA help please!!
Hello, Please help with formula in Col D Table 1 to lookup values from Col H Table 2. Thank you in advance.
| 1 | A | B | C | D | E | F | G | H |
| 2 | Table 1 | Table 2 | ||||||
| 3 | PRODUCT ID | COMMENT CODE | COMMENT DATE | Lookup Value From Table2 Column H | PRODUCT ID | COMMENT CODE | COMMENT DATE | |
| 4 | 000101 | ABC1 | 02/04/2016 | 07/07/2019 | 000099 | ABC1 | 07/05/2019 | |
| 5 | 000101 | ABC2 | 02/06/2016 | 07/08/2019 | 000100 | ABC2 | 07/06/2019 | |
| 6 | 000103 | ABC1 | 02/06/2016 | 07/11/2019 | 000101 | ABC1 | 07/07/2019 | |
| 7 | 000103 | ABC2 | 02/07/2016 | 000101 | ABC2 | 07/08/2019 | ||
| 8 | 000104 | ABC3 | 02/08/2016 | 07/07/2019 | 000103 | ABC1 | 07/11/2019 | |
| 9 | 000103 | ABC2 | ||||||
| 10 | 000104 | ABC3 | 07/07/2019 |
As variant for
in D4
=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")
4 Replies
As variant for
in D4
=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")Thanks a lot, that's what I need SergeiBaklan
marislav , you are welcome
Himarislav
Please use below formula in Col D of Table 1:
VLOOKUP(C6,$H$6:$I$12,2,0)
Sample file is also attached for more understanding.
Thanks,
Tauqeer
