Compare 2 sheets with particular columns

Solved/Closed
SunilD - Mar 4, 2019 at 09:09 AM
 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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 4, 2019 at 11:41 AM
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
0
HI Trowa,

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