Compare 2 sheets with particular columns
Solved/Closed
Related:
- Compare 2 sheets with particular columns
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Plants vs zombies 2 pc download - Download - Strategy
- Euro truck simulator 2 download - Download - Simulation
- Team fortress 2 download - Download - Shooters
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Mar 4, 2019 at 11:41 AM
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
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
Mar 5, 2019 at 04:16 AM
this did worked!!
thanks for your support...