Excel find a value <>2#'s &get a value beside
Solved/Closed
Related:
- Excel find a value <>2#'s &get a value beside
- Excel drop down list 2 columns - Guide
- Excel: Partial Matches in 2 Different Cells ✓ - Forum - Excel
- Excel/VBA - Select cells between 2 keywords - How-To - Excel
- Calculate Time Between 2 Dates in Excel - How-To - Excel
- Excel - Extract a list from 2 columns - How-To - Excel
2 replies
rizvisa1
Apr 24, 2010 at 12:09 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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