My first request! VBA help

[Killen]

I'm sure this is easy for some, but for me...... :banghead:

I keep drawing a blank.

Ingredients:
Sheet 1 and Sheet 2
Columns F and G in Sheet 1
Columns B and C in Sheet 2
Columns J and K in Sheet 1

All data is manually entered (copy/paste) from an ERP resource.

I want a VB program to compare F and G to B and C and alter Columns J and K if there is a match between F and G to B and C.

Eaxmple on sheet 2:

Operation Number.. Part Number

450....................... 06393-10002-SF1
310....................... 5311079SK01
100....................... 5311247SK01


If there is an exact match in the columns noted (Row with 450 / 06393-10002-SF1) on Sheet 1, I want the cell in Columns J and K in that same row to change to 0



Upload of document keeps failing. But I have started this learning experience using the i,j idea....

[Bob Phillips]

Why not just use VLOOKUP?

[Killen]

Thats what I'm doing now. Concantenating and Vlookup. Figured to have less columns and less ability for others to mess things up is better. Offering a button to do everything....

[Bob Phillips]

I don't see why you need to concatenate, but anyway, formulae are simpler.