Excel find a value <>2#'s &get a value beside
Solved/Closed
Related:
- Excel find a value <>2#'s &get a value beside
- 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
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 24, 2010 at 12:09 PM
Apr 24, 2010 at 12:09 PM
Try this
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,TRUE), "", VLOOKUP(A1,Sheet2!A:B,2,TRUE))
or this
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,TRUE)),"",VLOOKUP(A1,Sheet2!A:B,2,TRUE))
which is same but the later handles any error too
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,TRUE), "", VLOOKUP(A1,Sheet2!A:B,2,TRUE))
or this
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,TRUE)),"",VLOOKUP(A1,Sheet2!A:B,2,TRUE))
which is same but the later handles any error too