HLookup and If Functions

[MFurrick]

How do I pull data from incoming data worksheet to destination wksht?

1st worksheet (destination)
M-YY
Product 1 label 1 Criteria 1 LOB1
Product 1 label 1 Criteria 2 LOB1
Product 1 label 1 Criteria 3 LOB1
Product 1 label 1 Criteria 4 LOB1
Product 1 label 1 Criteria 5 LOB1
Product 1 label 1 Criteria 6 LOB1
Product 1 label 1 Criteria 7 LOB1
Product 1 label 1 Criteria 8 LOB1
Product 1 label 2 Criteria 1 LOB1
Product 1 label 2 Criteria 2 LOB1
Product 1 label 2 Criteria 3 LOB1
Product 1 label 2 Criteria 4 LOB1
Product 1 label 2 Criteria 5 LOB1
Product 1 label 2 Criteria 6 LOB1
Product 1 label 2 Criteria 7 LOB1
Product 1 label 2 Criteria 8 LOB1

2nd worksheet (incoming data)


label 1 label 2 and so on
product 1 Criteria 1 LOB1 1
product 2 Criteria 2 LOB2 2
product 3 Criteria 3 LOB1 3
product 4 Criteria 4 LOB2 4
product 5 Criteria 5 LOB1 5
product 1 Criteria 6 LOB2 6
product 2 Criteria 7 LOB1 7
product 3 Criteria 8 LOB2 8
product 4 Criteria 1 LOB1 9
product 5 Criteria 2 LOB2 10
product 1 Criteria 3 LOB1 11
product 2 Criteria 4 LOB2 12
product 3 Criteria 5 LOB1 13
product 4 Criteria 6 LOB2 14
product 5 Criteria 7 LOB1 15
product 1 Criteria 8 LOB2 16