Ok here is my problem. I am to have all of figures in sheet two and sheet one will be a spread sheet to fill out. Basically in the field of B4 on sheet one they will enter a dept number. In the field of B8 it will pull the figure from sheet two based on the figure they entered. Example of an IF formula I tried to use:
IF(B4 = 34, Sheet2!B34, IF(B4 = 35, Sheet2!B35, IF(B4 = 36, Sheet2!B36,IF(B4 = 37, Sheet2!B37))))
Ok that works find but I have 98 different dept numbers they can enter to pull figures from. Problem is on my computers at work they have an older excel on it and it is limited to the number of nested formulas can be used.
As you can see depts are in order on Sheet Two. Anyone know of an easier formula I could use to get this to work on Excel? I am sure there has to be a way.
Thank you so much!
2007-11-05
06:20:44
·
6 answers
·
asked by
thepick48
2