Excel 2007 populating a cell based on values in other cells

Hi,

How are you determining the code? Are you using a vlookup or is it hard coded in the formula?

Steve

Hi Steve,

It is hardcoded in the formula. There are seven of them:

B1 = 001
C1 = 002
D1 = 003
E1 = 004
F1 = 005
G1 = 006
H1 = 007

The values in B1 through H1 can change but the value in A1 is hard coded based on the fact that there is a value in the cell B1 through H1. The IF statement that covers one cell is "=IF(B1836,"001","")". I need this type of formula to work for multiple cells.

Thanks!