• 408K Members
• 7,823 Online
• 465K Conversations
SOLVED

New Contributor

# 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 ValueFrom 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

4 Replies

# Re: Need FORMULA help please!!

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

Solution

# Re: Need FORMULA help please!!

As variant for

in D4

``=IFERROR(INDEX(\$H:\$H,MATCH(1,INDEX((\$F:\$F=\$A4)*(\$G:\$G=\$B4),0),0)),"no such")``

# Re: Need FORMULA help please!!

Thanks a lot, that's what I need @Sergei Baklan

# Re: Need FORMULA help please!!

@marislav , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies