Check column wjth al least 2 conditions

[joao56777]

Hello,

I would like that this huge and extraordinary community could help me.

I have a excel for control the welding equipment verification. After the verification is done, I would like the certificate could be automatically done by choosing some variables.

I think the best one is the Index formula, but I have issues in the way the document is builded.

Attached the community have the excel document, welding machines.

I have made some snaps to explain.
In 1st photo, we have the blue lines that means are the variables of searching information, the verification number (1st verification, 2nd verification, 3th verification...) and the welding machine number (SD-01, SD-02, SD-03...).

In that verification, we have 3 variables, they are, Amperage, voltage and wire feed speed, and I want to put them on the 2nd photo, that is the certificate of the "welding machine".

Could the community help me
Regards?
Jo?o

[AliGW]

Are you still using Excel 2013?

[joao56777]

Are you still using Excel 2013?

Hello Dear,

This is a version from a company that I'm working with. They don't have any update of Microsoft Office.

Thats the way it is.

Thanks in advance for your's reply

[Glenn Kennedy]

This is made MUCH more complicated by the totally inappropriate use of pretty looking, but EVIL merged cells (the spawn of Satan) in WE column A and in Final B/C, D/E, etc.

Your strange values in We column L are dates... not m/min...

In Final, B23, copied across and down:

=INDEX('Welding Equipment'!$J$6:$X$19,MATCH(Final!$R$1,'Welding Equipment'!$A$6:$A$19,0)+ROWS(B$23:B23)-1,MATCH(Final!$R$3,'Welding Equipment'!$J$3:$X$3,0)+INT((COLUMNS($B23:B23)-1)/2))

[joao56777]

Hello Dear Mr Glenn,

Incredible work. You are a totally Master

Please, could you explain me how do you get this?

Thanks for all

[Glenn Kennedy]

=INDEX('Welding Equipment'!$J$6:$X$19,MATCH(Final!$R$1,'Welding Equipment'!$A$6:$A$19,0)+ROWS(B$23:B23)-1,MATCH(Final!$R$3,'Welding Equipment'!$J$3:$X$3,0)+INT((COLUMNS($B23:B23)-1)/2))

Red. Return from this range
Orange the first row where an exact match for the content of R1 is found
Green and the first column where an exact match for the content of R3 is found.
Blue, increment the rows by one as the formula is copied down (a counter, ruiing from 0,1,2,3, etc)
Purple, increment the columns by 1 for every two columns (your ghastly merged cells...) the formula is copied across (again a counter, returning 0,0,1,1,2,2, etc).

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[joao56777]

Hello Mr Glenn,

Let me please, check if its OK. If everything is OK, tomorrow I will put the thread as solved, or, I will be back knocking your door

Regards my friend

[joao56777]

Hello Mr Glenn,

I would like to talk with you about this subject.
When I choose the imagine the SD01 Equipment and 1st verification everything is OK. Please look
Attachment 797147
Attachment 797150

When I choose the 2nd, didnot seems ok. I have arranged the columns if could be more easy, or you could arrange the columns to be more easy to get the result.

Could you help me?

[Glenn Kennedy]

Just change the bits in red:

=INDEX('Welding Equipment'!$G$6:$AX$19,MATCH(Final!$R$1,'Welding Equipment'!$A$6:$A$19,0)+ROWS(B$21:B21)-1,MATCH(Final!$R$3,'Welding Equipment'!$J$3:$AX$3,0)+INT((COLUMNS($B21:B21)-1)/2))

[joao56777]

Thanks for all.