Hello all,
Please refer to the attached xls sheet to understand my problem description.
How do I compare value A1 on sheet 1 to A1:A6 on sheet2? Once I get a match for A1 on sheet 1 to Ax (x=1-6) on Sheet 2, I want to take the value of Bx (same number as the x in Ax) on sheet 2 and paste it in A3 on sheet 1. I want to loop through A1:A5 on sheet one doing this same thing.
Thanks,
Adam