Compare 2 sheets with particular columns
Solved/Closed
Related:
- Compare 2 sheets with particular columns
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Five nights in anime 2 - Download - Adult games
- Call of duty modern warfare 2 2022 free download - Download - Shooters
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...