Previous Topic Next Topic

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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)))
0

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses