 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007How to have cell data determined by other cell's data
I've got Excel 2002. In my spreadsheet, column B is a lit of boxes that our parts are packaged in. In column C, I want to list the dimensions for the boxes listed in B. How can I write a formula so for all of column C, it will read the B for that row and put in the correct dimensions in C based on what box is listed in B? Thanks. Mark A better explanation, layout and examples would be helpful  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > I've got Excel 2002. In my spreadsheet, column B is a lit of boxes that > our parts are packaged in. In column C, I want to list the dimensions for [quoted text clipped - 3 lines] > > Mark Column B could contain any of the following box names: Master 2 wheel 4 wheel 2 special For column C, I want the correct dimensions to be listed based on what box is listed in column B for that row. I think I'm starting to figure it out with nested IF statements, but there is a limit of 7. What if I need more than 7 nested IF statements? >A better explanation, layout and examples would be helpful > [quoted text clipped - 5 lines] >> >> Mark And now, for the rest of the story???????????????? SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Column B could contain any of the following box names: > [quoted text clipped - 18 lines] >>> >>> Mark I don't know what you mean???????????????? > And now, for the rest of the story???????????????? > [quoted text clipped - 20 lines] >>>> >>>> Mark Perhaps it would be useful to know how these dimensions are determined. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I don't know what you mean???????????????? > [quoted text clipped - 22 lines] >>>>> >>>>> Mark The dimensions are predetermined outside of Excel. I have a separate sheet that lists the box names and the dimensions for each box. I now need to marry that info to our product list so that: col A=part number col B=box1 name col C=box1 dimensions The box dimesions are written into the IF statements that I've been starting to play with. But IF statements have a limit of 7 nested statements and I have 10 possible boxes, so how would I handle boxes 8-10? I hope I'm making this clearer. > Perhaps it would be useful to know how these dimensions are determined. > [quoted text clipped - 24 lines] >>>>>> >>>>>> Mark Not really since you don't give examples. Perhaps a select case macro. Can't you post your If's. You do make it difficult to assist you. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > The dimensions are predetermined outside of Excel. I have a separate > sheet that lists the box names and the dimensions for each box. I now [quoted text clipped - 39 lines] >>>>>>> >>>>>>> Mark No offense but I've posted much less in the past and gotten much more help. > Not really since you don't give examples. Perhaps a select case macro. > Can't you post your If's. You do make it difficult to assist you. [quoted text clipped - 42 lines] >>>>>>>> >>>>>>>> Mark Hey, I'm not the one looking for help. Geeeeeeeez. Look in the help index for VLOOKUP SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > No offense but I've posted much less in the past and gotten much more > help. [quoted text clipped - 46 lines] >>>>>>>>> >>>>>>>>> Mark hi. could you give examples of what is in column B? formulas do return values but they tend to get really picky. regards FSt1 > I've got Excel 2002. In my spreadsheet, column B is a lit of boxes that our > parts are packaged in. In column C, I want to list the dimensions for the [quoted text clipped - 3 lines] > > Mark Example using the IF statements: Col A Col B Col C A123 4 Wheel =IF(D57="4 wheel","14 x 12",IF(D57="2 wheel","6 x 9")) A125 2 Wheel =IF(D57="4 wheel","14 x 12",IF(D57="2 wheel","6 x 9")) So with the IF statements I can get the correct box dimensions into col C, but IF statements have a limit of 7 nested statements. But I will need more than 7 statements, so how can I achieve my goal of col C populating with the correct data based on col B? > hi. > could you give examples of what is in column B? [quoted text clipped - 13 lines] >> >> Mark Use a VLOOKUP table !!!! > Example using the IF statements: > [quoted text clipped - 27 lines] >>> >>> Mark |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.