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

Comparing columns and returning value
ll -
kittu -

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

2 responses
Lookup partial text contained in cell range
Tom -
Tom -

4 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses