# cell comparison betwen sheets

• 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,

## Files

• Hi,

if A2 value on sheet1 found, you want corresponding value on sheet2 to A4 on sheet1?

Quote from pfeiffer

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 think this may do what you want. Place this formula in cell A3 of Sheet 3 and then copy it down...

=VLOOKUP(Sheet1!A1,Sheet2!\$A\$1:\$B\$6,2,0)

If I've been helpful, let me know. If I haven't, let me know that too.

• Hello dangelor, the formula worked partial for what I want. But I need to compare A1 on sheet 1 to every value in column A on sheet 2. When I find a match, I need to get the value for column B in the same row that matched A1 on sheet1. I need to do this for ever value in Column A on sheet 1. I think I am going to have to use vba to do this. I know how to program, but not vba. Thanks for your help.

• Is this what you wanted?

## Files

If I've been helpful, let me know. If I haven't, let me know that too.

• It worked great

Sorry it took so long to letyou know, but your formula worked great. Thanks for your help.