How to have cell data determined by other cell's data

  • Thread starter Thread starter Mark Christensen
  • Start date Start date
M

Mark Christensen

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
 
hi.
could you give examples of what is in column B?
formulas do return values but they tend to get really picky.

regards
FSt1
 
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?
 
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.
 
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.
 
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?
 
Use a VLOOKUP table !!!!




Mark Christensen said:
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?
Click to expand...
 
Back
Top