• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple IF Statements across multiple cells based on a LIST in Column A

W

Weg

New Member
Hello, this is my 1st post so please be gentle!


I have successfully created a LIST which is used down multiple rows in column A.

Based on the result of the LIST selection say in A1, I need to then insert a NUMBER into B1, and then based on the result of B1, populate a NUMBER in C1.


Example ...

A1 = ABC, then B1 = 123, then if B1 = 123, then C1 = 987 etc


Each ROW has multiple numeric answers needed based on what is selected in A.


I'm trying to weave an "IF" statement but it seems to complicated ... assistance would be greatly appreciated, many thanks.


Weg
 
Weg


Firstly, Welcome to the Chandoo.org Forums


Concentrate on 1 cell at a time


In B1 you need a formula that will change based on the value in A1

Code: 
=If(A1="ABC", 123, "Answer if it isn't ABC")


Then in C1 you need a formula that will change based on the value in B1

=If(B1="123, 987, "Answer if it isn't 123")


What your going to come up against is if there are more than a few values in Column A the If will get very large

In that case there are other ways like VLookup etc to lookup a value from a list and return a matching answer
 
Hello Hui, many thanks for your prompt response.


I've revisited my spreadsheet and I'm now trying this new approach and could do with some of your wisdom as I'm trying for the 1st time a multiple IF statement!


Based on selection in A1 (ie: ABC), then B1 needs to be 123, C1 needs to be 321 etc. But if DEF is selected in A1, then B1 needs to be 456 and C1 needs to be 654 etc.


I have 10 options in drop down box in column A down 30 rows to populate (hopefully easily?!)


NB: the results for each column B,C, D etc are fixed and solely dependant upon selected result of A.


Hope this makes more sense and that you can assist me yet again.


Kind regards - Weg.
 
Can you post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi, Weg!


Give a look at this file:

https://dl.dropbox.com/u/60558749/Multiple%20_IF_%20Statements%20across%20multiple%20cells%20based%20on%20a%20LIST%20in%20Column%20A%20%28for%20Weg%20at%20chandoo.org%29.xlsx


Check if it is what you wanted (I'm not sure if I fully understood the requirement) and if the implementation it's suitable for your needs.


Just advise if any issue.


Regards!
 
Thanks SirJB7 and Hui, I think you have given me the answer I was looking for, I'll give the Vlookup formula.


Many thanks again to you both, it is appreciated.


All the best,


Weg
 
Hi, Weg!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 
You must log in or register to reply here.
Back
Top