VLookup

[Closed]
Report
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!


1 reply

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)))