• 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.

I need help quick!

B

bstrunk312

New Member
I am trying to use the statement "=IF(G151=I123,A125)" to pull a name in reference to another piece of data and I would like to string this with other IF statements so no matter what information is in G151, the corresponding I column variable will reference to the A variable column, however "=IF(G151=I123,A125),IF(G151=I110,A115)..." comes back with an error and #VALUE! error. I have been told I need a function to link these together but I do not know what it is. Can anyone help me solve this?
 
I may need to explain more, it is confusing but I don't think it should be as complicated as I am making it in my head
 
Bstrunk312


Firstly, Welcome to the Chandoo.org Forums


As a new user I encourage all people to read the 3 Sticky Green Posts at the main forum page

Especially http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


In there you will see that we encourage people to use Good names for their posts

So instead of: I need help quick!

Preferred: Problem with If() function


This is requested for 2 reasons

Firstly, It makes searching for problems/solutions more meangingful

Secondly, You will get a quicker response, as the readers here will see the title "Problem with If" and think I know how to help there, where as with a title like "I need help quick!" we have to actually read the whole post to see if it is in our area of expertise
 
You must log in or register to reply here.
Back
Top