I am trying to achieve this goal.
Example
If Cell A1 = MSM then CELL A4 will be cell A3+120
If Cell A2 = ARCOM then CELL A4 will be cell A3+90
and so on I probally going to have 5 different if statments but I want to be able to put them all in the same cell. I just need a little assistance on how to do that formula and what I need to do if I add an if statement. Thank you in advance and any assistance will be appreciated
you will probably be better off using a vlookup.
something like...
=A3+vlookup(A1,$D$1:$E$5,2,false)
where D1:E5 contains the variables and the values
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What if Cell A1 = MSM and Cell A2 = ARCOM? or would that never happen? Since you have A3 as a number (which is used to populate A4) where would your next IF criteria go?
There are probably two ways to go with this; either nested IFs or a VLOOKUP
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
@FDiddins Thank you very much the Vlookup worked perfectly, @ChemistB thank you very much also for your assistance
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks