Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc.
Solved/Closed
wreidmetals
Posts
2
Registration date
Tuesday January 21, 2014
Status
Member
Last seen
January 22, 2014
-
Jan 21, 2014 at 03:41 PM
wreidmetals Posts 2 Registration date Tuesday January 21, 2014 Status Member Last seen January 22, 2014 - Jan 22, 2014 at 10:34 AM
wreidmetals Posts 2 Registration date Tuesday January 21, 2014 Status Member Last seen January 22, 2014 - Jan 22, 2014 at 10:34 AM
Trying to create a formula where I have a merged cell (E18) that if 1, 2, 3, 4 or 5 is entered I want the end result to equal the contents of G18, G19, G20, G21 or G22. Basically I have a "Formal Offer" sheet where the formula will be nested but the data is to be extracted from the "data entry" sheet. So bottom line on the "data entry" sheet if E18 = 1 then I need the cell on the "Formal Offer" sheet to read G18 from the "data entry" sheet. If E18 = 2 then I need the cell on the "Formal Offer" sheet to read G19 from the "data entry" sheet, so on and so forth...I've tried researching this to no avail, I am not too adept at creating formulas and need some expert opinion. Can someone enlighten me please?
Related:
- Formula:IF E18 = 1, 2, 3, 4 or 5 Then End Result = G18, G19 etc.
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
wreidmetal, wierd name! But hey what is a name?
Hang in there, I am certain that INDEX will do what you want (https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd?ocmsassetid=hp010342608&correlationid=83a75259-3757-46a1-9a4d-bf4c6049e21e&ui=en-us&rs=en-us&ad=us).
https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd?ocmsassetid=hp010342608&correlationid=83a75259-3757-46a1-9a4d-bf4c6049e21e&ui=en-us&rs=en-us&ad=us
Take a look, and if you need help, let us know.
Have Fun!
//ark
-Moderator/Contributor
Hang in there, I am certain that INDEX will do what you want (https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd?ocmsassetid=hp010342608&correlationid=83a75259-3757-46a1-9a4d-bf4c6049e21e&ui=en-us&rs=en-us&ad=us).
https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd?ocmsassetid=hp010342608&correlationid=83a75259-3757-46a1-9a4d-bf4c6049e21e&ui=en-us&rs=en-us&ad=us
Take a look, and if you need help, let us know.
Have Fun!
//ark
-Moderator/Contributor
wreidmetals
Posts
2
Registration date
Tuesday January 21, 2014
Status
Member
Last seen
January 22, 2014
Jan 22, 2014 at 10:34 AM
Jan 22, 2014 at 10:34 AM
Hey ac3mark - thanks for the response. Yeah the name is by conglomeration, not by design (mix of me and work!). Anyhow, I tried INDEX and it "sort of" worked. I was able to institute that formula on the data entry sheet. From the offer sheet I simply put "=" cell from data entry sheet and got it that way. Good enough for me! Thanks for the help and the info - much appreciated!
BTW...the link you provided above appears to be dead.
BTW...the link you provided above appears to be dead.
