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
Hello,
I'm working with two formulas and trying to make one formula out of them! I can't seem to find a way of putting the two together!
I'm using the following formula :'=IF(ISERROR(VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE)),VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE),VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE))
I'm trying to add this formula to the other formula : =VLOOKUP(D7,'In stock production'!A2:B61,2,FALSE),
I would appreciate it if somebody can assist or give me an indication of how to go about it!
I'm working with two formulas and trying to make one formula out of them! I can't seem to find a way of putting the two together!
I'm using the following formula :'=IF(ISERROR(VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE)),VLOOKUP(D7,'In stock mechanical'!A2:B61,2,FALSE),VLOOKUP(D7,'In stock electrical'!A2:B42,2,FALSE))
I'm trying to add this formula to the other formula : =VLOOKUP(D7,'In stock production'!A2:B61,2,FALSE),
I would appreciate it if somebody can assist or give me an indication of how to go about it!
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)))
