![]() |
how to use if statements or vlookups
I am trying to populate a table based upon data in another table. Based upon
what is entered into two fields Input Review Yr: 2009 (k7) Review month 1 (M7) Results Month Util. % Month Util. % Jan-08 0.0% Jul-08 65.0% Feb-08 32.0% Aug-08 85.0% Mar-08 42.0% Sep-08 95.0% Apr-08 45.0% Oct-08 100.0% May-08 32.0% Nov-08 25.0% Jun-08 35.0% Dec-08 45.0% list of values row / col B C 109 Dec-07 45.0% 110 Jan-08 0.0% 111 Feb-08 32.0% 112 Mar-08 42.0% 113 Apr-08 45.0% 114 May-08 32.0% 115 Jun-08 35.0% 116 Jul-08 65.0% 117 Aug-08 85.0% 118 Sep-08 95.0% 119 Oct-08 100.0% 120 Nov-08 25.0% 121 Dec-08 45.0% 122 Jan-09 35.0% 123 Feb-09 65.0% 124 Mar-09 95.0% 125 Apr-09 22.0% 126 May-09 26.0% 127 Jun-09 28.0% 128 Jul-09 30.0% 129 Aug-09 32.0% 130 Sep-09 36.0% 131 Oct-09 38.0% 132 Nov-09 40.5% 133 Dec-09 65.0% |
All times are GMT +1. The time now is 09:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com