Compare 2 sheets with particular columns [Solved/Closed]

Report
-
 SunilD -
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

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
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...

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!