I am attaching a workbook with 3 tabs and I am hoping to find help with a formula for cell B2 of worksheet "FTE Requirements".
I would like a formula that will say if A2 (On FTE Requirements Worksheet) is equal to anything in the range of cells A2 - A 13 on worksheet Service Activity Info then cell B2 will equal the amount in column F (Total Hours REquired for Service Activity) in the cell on the same row. I would then copy the formula down to cell B7 so each cell between B2 and B7 would do the same.
So for example on the FTE Requirements Worksheet:
B2 would be 450
B3 would be 170
B4 Would be 3,150
B7 Would be 9,558
All based on the cell range on worksheet Service Activity Info A2:F13
I had some help with a similar formula earlier but this one is on a different worksheet and I can't seem to make it work.
Thanks to anyone that might be able to help me with this one. I am not even sure if it is possible. I am trying to create something that will be very simple for others that do not use excel much at all to use.
Bookmarks