# VLookup

[Closed]
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)))