Compare 2 sheets with particular columns

SunilD - Mar 4, 2019 at 09:09 AM
 SunilD - Mar 5, 2019 at 04:16 AM
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,

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

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Mar 4, 2019 at 11:41 AM
Hey SunilD,

Try the following formula in column B of sheet2:

If you don't like the zero's then use:

Best regards,
HI Trowa,

this did worked!!
thanks for your support...