finding multiple values that match to return certain values in a row

Hi

Welcome to the forum.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is a sample of the data I am messing with

Hi


In sheet2!L2 use the following formula and drag down

Formula:

Please Login or Register  to view this content.

In sheet1 use the following formulas to A2,B2,C2,D2,E2,F2 and G2 (sorry I do not know you want in H2) and drag down

Formula:

Please Login or Register  to view this content.

See the file

For some reason it is downloading as a .php document, know any way to fix that?

Originally Posted by TexasEE

For some reason it is downloading as a .php document, know any way to fix that?

Are you referring to the post # 4 file?

Try this with extension xlsb

Also I am confused at what this formula is supposed to be doing:
=SUMPRODUCT(--(C2=Sheet3!$R$1:$R$2000)*(D2=Sheet3!$C$1:$C$2000)*(F2+0=Sheet3!$Q$1:$Q$2000)*(G2=Sheet3!$V$1:$V$2000)*ROW(A$1:A$2000))

That formula find the Excel row where
C2=Sheet3!$R$1:$R$2000 and D2=Sheet3!$C$1:$C$2000 and F2+0=Sheet3!$Q$1:$Q$2000 and G2=Sheet3!$V$1:$V$2000

For first row in sheet2 that value is 79 so Sheet3!$A$79:$AT$79 has all values we need.

yeah I'm not sure what that value is, those numbers like 449-076-004-103 are the names of the harness' not actual equations