| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| more if statements and vlookups | Excel Discussion (Misc queries) | |||
| IF STATEMENTS COMBINED WITH VLOOKUPS | Excel Worksheet Functions | |||
| Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
| Pivot tables, IF statements, vlookups? | Excel Worksheet Functions | |||
| Vlookups | Excel Discussion (Misc queries) | |||
Hybrid Mode
