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 ...
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