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
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Resident evil 2 remake free download - Download - Horror
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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...