Compare 2 sheets with particular columns [Solved]

- - Latest reply:  SunilD - Mar 5, 2019 at 04:16 AM
Hello,
hear is the situation,
sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)"

& other side in sheet2 i have only item code item codes in column A & except column B all columns are full with other info,

so
i want to compare both sheets with column "A"(item code) and if any record mach the Rack ID from sheet1 must get copied in sheet2 in column B to the same item code.




System Configuration: Windows / Chrome 74.0.3705.0
See more 

1 reply

Posts
2570
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2019
379
0
Thank you
Hey SunilD,

Try the following formula in column B of sheet2:
=VLOOKUP(A2,Sheet1!A:B,2,0)

If you don't like the zero's then use:
=IF(VLOOKUP(A2,Sheet1!A:B,2,0)=0,"",VLOOKUP(A2,Sheet1!A:B,2,0))

Best regards,
Trowa
HI Trowa,

this did worked!!
thanks for your support...
Respond to TrowaD