Jul 30 2019 12:59 PM
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 |
Jul 30 2019 01:09 PM
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
Jul 30 2019 01:12 PM
SolutionAs variant for
in D4
=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")
Jul 30 2019 01:24 PM
Thanks a lot, that's what I need @Sergei Baklan
Jul 30 2019 01:41 PM - last edited on Nov 11 2023 05:05 PM by
@marislav , you are welcome
Jul 30 2019 01:12 PM
SolutionAs variant for
in D4
=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")