Getting Information from Two Different Columns

[illogical90]

Hello All,


I need support in below, I have two columns with different targets (column X for Official and column Y for Stretched). What I am trying to extract that there is a cell which contains drop down list of "Official" and "Stretched" if that cell contains "Official" than the certain column will show me only Official Targets or when I will select "Stretched" it gives the values of Stretched targets. I did something but I am unable to combine formulas which can give information for both at the same time.


Will be thankful for your help.


Regards.

 

[etaf]

you could use an IF to choose between the 2 different formulas for the drop down with "Official" OR "Stretched"

=IF ( cell with drop down = "official" , lookup official target formula , IF ( cell with drop down = "stretched", lookup stretched target formula, "" ))

 

[illogical90]

Hello etaf,

I already tried and it says too many arguments =IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE, IF(Parameters!A2="Official",VLOOKUP(A2,,Targets!A2:G39,6,0))).

I am not sure what I am doing wrong here. Below is the link for file it might be someone can help.

https://www.dropbox.com/s/70g79zu9s0rr925/Work (version 1).xlsx?dl=0

 

[jmacleary]

You have too many commas in the second vlookup. Change your formula to: =IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE, IF(Parameters!A2="Official",VLOOKUP(A2,Targets!A2:G39,6,0)))

 

[illogical90]

You have too many commas in the second vlookup. Change your formula to: =IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE, IF(Parameters!A2="Official",VLOOKUP(A2,Targets!A2:G39,6,0)))

Hi Jma,

It still gives me the error of too many arguments. :S

 

[jmacleary]

OK I have just reread your original post, and realise that whet you are trying to do can't be done using vlookup. Vlookup will only ever return the first match. Try googling 'excel cascading dropdown list' - there are several solutions that appear.

 

[etaf]

try closing the vlookup bracket formula in your first vlookup
change
=IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE, IF(Parameters!A2="Official",VLOOKUP(A2,Targets!A2:G39,6,0)))
to
=IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE), IF(Parameters!A2="Official",VLOOKUP(A2,Targets!A2:G39,6,0),"Condition if A2 does not = either"))

VLOOKUP(A2,Targets!A2:G39,6,0)
o needs to be the word true or false normally - 0 will

=IF(Parameters!A2="Stretched",VLOOKUP(A2,Targets!A2:G39,7,FALSE), IF(Parameters!A2="Official",VLOOKUP(A2,Targets!A2:G39,6,false),"Condition if A2 does not = either"))