How to use multi cell formulas in Microsoft excel
up vote
-1
down vote
favorite
Ok i need some help, i am trying to find out how to do multi line conditional formatting with specific values.
Example: if c22 = 3rd street then c23= work order number (123455)
Can someone point me in the right direction on how to formulate that?
Added 11-23-2018
ok, im still fairly new to excel, what i know i learned on my own, so my lingo may not be the same as the rest of you. But what im doing is a project for work, instead of putting the same info in multiple times, i need a way that will put the values in based on the job number. Example: if job number equals 4460019 in the C4 cell, then i need D4 cell to show, 13.2 kv Transformer Change out.
I did just google the Index and vlookup commands which i can use on other features of this same workbook i believe. If im understanding it right, it only gives you a reference. What im looking for is something that will automate Entrees for a cell based on the job work order number. This is a non stop growing database sort of speak. I do have it built exactly how i want it in Microsoft access database, i just got to do an excel version of that same database. Hopefully that makes sense...
microsoft-excel
asked Nov 20 at 18:53
Bobby Maynard
11
add a comment |
up vote
-1
down vote
favorite
Ok i need some help, i am trying to find out how to do multi line conditional formatting with specific values.
Example: if c22 = 3rd street then c23= work order number (123455)
Can someone point me in the right direction on how to formulate that?
Added 11-23-2018
ok, im still fairly new to excel, what i know i learned on my own, so my lingo may not be the same as the rest of you. But what im doing is a project for work, instead of putting the same info in multiple times, i need a way that will put the values in based on the job number. Example: if job number equals 4460019 in the C4 cell, then i need D4 cell to show, 13.2 kv Transformer Change out.
I did just google the Index and vlookup commands which i can use on other features of this same workbook i believe. If im understanding it right, it only gives you a reference. What im looking for is something that will automate Entrees for a cell based on the job work order number. This is a non stop growing database sort of speak. I do have it built exactly how i want it in Microsoft access database, i just got to do an excel version of that same database. Hopefully that makes sense...
microsoft-excel
asked Nov 20 at 18:53
Bobby Maynard
11
1
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
2
FYI, it doesn't sound like what you need is conditional formatting, you may be looking forVLOOKUPorINDEX/MATCH, but we can't be sure unless you do as @K7AAY asks
– cybernetic.nomad
Nov 20 at 19:06
1
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
Ok i need some help, i am trying to find out how to do multi line conditional formatting with specific values.
Example: if c22 = 3rd street then c23= work order number (123455)
Can someone point me in the right direction on how to formulate that?
Added 11-23-2018
ok, im still fairly new to excel, what i know i learned on my own, so my lingo may not be the same as the rest of you. But what im doing is a project for work, instead of putting the same info in multiple times, i need a way that will put the values in based on the job number. Example: if job number equals 4460019 in the C4 cell, then i need D4 cell to show, 13.2 kv Transformer Change out.
I did just google the Index and vlookup commands which i can use on other features of this same workbook i believe. If im understanding it right, it only gives you a reference. What im looking for is something that will automate Entrees for a cell based on the job work order number. This is a non stop growing database sort of speak. I do have it built exactly how i want it in Microsoft access database, i just got to do an excel version of that same database. Hopefully that makes sense...
microsoft-excel
asked Nov 20 at 18:53
Bobby Maynard
11
Ok i need some help, i am trying to find out how to do multi line conditional formatting with specific values.
Example: if c22 = 3rd street then c23= work order number (123455)
Can someone point me in the right direction on how to formulate that?
Added 11-23-2018
ok, im still fairly new to excel, what i know i learned on my own, so my lingo may not be the same as the rest of you. But what im doing is a project for work, instead of putting the same info in multiple times, i need a way that will put the values in based on the job number. Example: if job number equals 4460019 in the C4 cell, then i need D4 cell to show, 13.2 kv Transformer Change out.
I did just google the Index and vlookup commands which i can use on other features of this same workbook i believe. If im understanding it right, it only gives you a reference. What im looking for is something that will automate Entrees for a cell based on the job work order number. This is a non stop growing database sort of speak. I do have it built exactly how i want it in Microsoft access database, i just got to do an excel version of that same database. Hopefully that makes sense...
microsoft-excel
microsoft-excel
asked Nov 20 at 18:53
Bobby Maynard
11
asked Nov 20 at 18:53
Bobby Maynard
11
edited Nov 23 at 14:02
asked Nov 20 at 18:53
Bobby Maynard
11
asked Nov 20 at 18:53
Bobby Maynard
11
asked Nov 20 at 18:53
Bobby Maynard
11
11
1
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
2
FYI, it doesn't sound like what you need is conditional formatting, you may be looking forVLOOKUPorINDEX/MATCH, but we can't be sure unless you do as @K7AAY asks
– cybernetic.nomad
Nov 20 at 19:06
1
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11
add a comment |
1
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
2
FYI, it doesn't sound like what you need is conditional formatting, you may be looking forVLOOKUPorINDEX/MATCH, but we can't be sure unless you do as @K7AAY asks
– cybernetic.nomad
Nov 20 at 19:06
1
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11
1
1
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
2
2
FYI, it doesn't sound like what you need is conditional formatting, you may be looking for
VLOOKUP or INDEX/MATCH, but we can't be sure unless you do as @K7AAY asks– cybernetic.nomad
Nov 20 at 19:06
FYI, it doesn't sound like what you need is conditional formatting, you may be looking for
VLOOKUP or INDEX/MATCH, but we can't be sure unless you do as @K7AAY asks– cybernetic.nomad
Nov 20 at 19:06
1
1
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377067%2fhow-to-use-multi-cell-formulas-in-microsoft-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Please help us help you by clicking on edit and adding to your original post; Comments are for folks helping to ask, your answers should build up the original question. Taking a screenshot of what you have done and uploading it to a website like imgur.com then adding the weblink to the screenshot to your original post helps greatly.
– K7AAY
Nov 20 at 19:00
2
FYI, it doesn't sound like what you need is conditional formatting, you may be looking for
VLOOKUPorINDEX/MATCH, but we can't be sure unless you do as @K7AAY asks– cybernetic.nomad
Nov 20 at 19:06
1
Could you provide a sample about your problem? this will better for us to help you.
– Lee
Nov 21 at 1:11