VLookup
Closed
Gouws
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Dec 7, 2011 at 02:43 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 8, 2011 at 12:32 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 8, 2011 at 12:32 PM
Related:
- VLookup
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Excel 2007 Using vlookup function in VBA ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 8, 2011 at 12:32 PM
Dec 8, 2011 at 12:32 PM
But question is where you want to add this formula ?
it looks like your if statement is
=IF(iserror(vlookup_electrical), vlookup1_mech, vlookup2_electrical)
may be thats what you want
=IF(NOT(ISERROR(VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE))),VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE),IF(NOT(ISERROR(VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE))),VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE),VLOOKUP(D7,'In stock production'!A2:B61,2,FALSE)))
it looks like your if statement is
=IF(iserror(vlookup_electrical), vlookup1_mech, vlookup2_electrical)
may be thats what you want
=IF(NOT(ISERROR(VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE))),VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE),IF(NOT(ISERROR(VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE))),VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE),VLOOKUP(D7,'In stock production'!A2:B61,2,FALSE)))