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

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
 
F

FSt1

hi.
could you give examples of what is in column B?
formulas do return values but they tend to get really picky.

regards
FSt1
 
M

Mark Christensen

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?
 
M

Mark Christensen

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.
 
D

Don Guillett

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.
 
M

Mark Christensen

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?
 
D

Don Guillett

Hey, I'm not the one looking for help. Geeeeeeeez. Look in the help index
for VLOOKUP
 
Top