how to use if statements or vlookups


B

Barb

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%
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top