Hello all. I'm actually not sure if this would be a macro, or maybe just a long If statement. Anyway, here's the deal...
Cell J3 of my workbook contains a drop-down menu to choose a fiscal year. The choices are FY1, FY2, and FY3.
1) If FY1 is chosen in J3, then K3 needs to pull the cell value from $F$41, and L3 needs to pull the cell value from $A$62.
2) If FY2 is chosen in J3, then K3 needs to pull the cell value from $F$64, and L3 needs to pull the cell value from $A$85.
3) If FY3 is chosen in J3, then K3 needs to pull the cell value from $F$87, and L3 needs to pull the cell value from $A$108.
If that could be done in just a big If statement in cells K3 and L3, that would be great. Just not sure how it would be done exactly.
Bookmarks