Forum Discussion

marislav's avatar
marislav
Copper Contributor
Jul 30, 2019
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 ...
excel
formula
vlookup
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 30, 2019

    marislav 

    As variant for

    in D4

    =IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 30, 2019

marislav 

As variant for

in D4

=IFERROR(INDEX($H:$H,MATCH(1,INDEX(($F:$F=$A4)*($G:$G=$B4),0),0)),"no such")
  • marislav's avatar
    marislav
    Copper Contributor
    Jul 30, 2019

    Thanks a lot, that's what I need SergeiBaklan 

Resources