How can I created a formula that will display a text output in cell 6 that is linked to a number in cell a.
Thanks in advance.
How can I created a formula that will display a text output in cell 6 that is linked to a number in cell a.
Thanks in advance.
b6 = if(a6=11,"john","")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I got this to work but if
=IF(H6= "11A","John") works fine
I am using a drop down menu,
When I change to =IF(H6= "11C","Dave") works fine
When I reselect the drop down for 11A I get (false)
The "" at the end of the formula that oeldere gave you will ensure that you get a blank rather than the word FALSE. However, it would be better if you set up a little table somewhere with all those values listed in one column and the names in an adjacent column, like this:
11A ..... John
11B ..... whoever
11C ..... Dave
and so on (suppose you do this in columns X and Y of the same sheet). Then you could just have this formula:
=IFERROR(VLOOKUP(H6,$X:$Y,2,0),"")
Hope this helps.
Pete
Will try that will let you know how it goes. Thanks
Perfect thanks
Well, that's good to hear - thanks for feeding back.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.
Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
I see, in addition, that your profile states that you are using Excel 2003, although you must have upgraded because the function IFERROR was not available for that version - please update your profile on the User CP screen to show your current version (it can affect what functions can be used in a potential solution).
Cheers,
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks