Auto-Populate Columns Based on Cell-Lookup Result?

PacSum

New Member
Joined
Jan 8, 2017
Messages
30
STARTING POINT:
NameBeginningChange #1Change #2Change #3Ending
Bob
Sarah

<tbody>
</tbody>

Data will be manually populated into the "Name" column above.

After populating into the name column, my goal is to have the subsequent columns automatically populated based on whether or not that name matches to male or female.


GENDER TABLE:
NameGender
BobM
SarahF

<tbody>
</tbody>

EQUATION TABLE:
GenderBeginningChange #1Change #2Change #3Ending
MmEquation#1mEquation#2mEquation#3mEquation#4mEquation#5
FfEquation#1fEquation#2fEquation#3fEquation#4fEquation#5

<tbody>
</tbody>

END GOAL:
NameBeginningChange #1Change #2Change #3Ending
BobmEquation#1mEquation#2mEquation#3mEquation#4mEquation#5
SarahfEquation#1fEquation#2fEquation#3fEquation#4fEquation#5

<tbody>
</tbody>

What would be the best way to go about trying to solve this?

Thanks in advance!
 
Last edited:

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,586
Office Version
365, 2016
Platform
Windows
try
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Name</td><td style=";">Beginning</td><td style=";">Change #1</td><td style=";">Change #2</td><td style=";">Change #3</td><td style=";">Ending</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Bob</td><td style=";">mEquation#1</td><td style=";">mEquation#2</td><td style=";">mEquation#3</td><td style=";">mEquation#4</td><td style=";">mEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Sarah</td><td style=";">fEquation#1</td><td style=";">fEquation#2</td><td style=";">fEquation#3</td><td style=";">fEquation#4</td><td style=";">fEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Name</td><td style=";">Gender</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Bob</td><td style=";">M</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">Sarah</td><td style=";">F</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">Gender</td><td style=";">Beginning</td><td style=";">Change #1</td><td style=";">Change #2</td><td style=";">Change #3</td><td style=";">Ending</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">M</td><td style=";">mEquation#1</td><td style=";">mEquation#2</td><td style=";">mEquation#3</td><td style=";">mEquation#4</td><td style=";">mEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style=";">F</td><td style=";">fEquation#1</td><td style=";">fEquation#2</td><td style=";">fEquation#3</td><td style=";">fEquation#4</td><td style=";">fEquation#5</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:B2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:C2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:D2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:E2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:F2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:B3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:C3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:D3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:E3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:F3</font>),0</font>)</td></tr></tbody></table></td></tr></table><br />
 

PacSum

New Member
Joined
Jan 8, 2017
Messages
30
And to add in case this creates another layer of complexity, the mEquation and fEquation will contain a cell reference to the first column. It is not a static equation. It will need to be able to reference column A.
 

PacSum

New Member
Joined
Jan 8, 2017
Messages
30
try
ABCDEF
1NameBeginningChange #1Change #2Change #3Ending
2BobmEquation#1mEquation#2mEquation#3mEquation#4mEquation#5
3SarahfEquation#1fEquation#2fEquation#3fEquation#4fEquation#5
4
5
6
7
8
9
10NameGender
11BobM
12SarahF
13
14
15
16GenderBeginningChange #1Change #2Change #3Ending
17MmEquation#1mEquation#2mEquation#3mEquation#4mEquation#5
18FfEquation#1fEquation#2fEquation#3fEquation#4fEquation#5

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet4

Worksheet Formulas
CellFormula
B2=VLOOKUP(VLOOKUP($A2,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A2:B2),0)
C2=VLOOKUP(VLOOKUP($A2,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A2:C2),0)
D2=VLOOKUP(VLOOKUP($A2,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A2:D2),0)
E2=VLOOKUP(VLOOKUP($A2,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A2:E2),0)
F2=VLOOKUP(VLOOKUP($A2,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A2:F2),0)
B3=VLOOKUP(VLOOKUP($A3,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A3:B3),0)
C3=VLOOKUP(VLOOKUP($A3,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A3:C3),0)
D3=VLOOKUP(VLOOKUP($A3,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A3:D3),0)
E3=VLOOKUP(VLOOKUP($A3,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A3:E3),0)
F3=VLOOKUP(VLOOKUP($A3,$A$11:$B$12,2,0),$A$17:$F$18,COLUMNS($A3:F3),0)

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
Makes sense. I had thought about this, but then as I was working through realized there was the qualifier that the equations are dynamic and will need to reference the first column. How would I implement a dynamic cell reference?
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,586
Office Version
365, 2016
Platform
Windows
could you give some examples
 

PacSum

New Member
Joined
Jan 8, 2017
Messages
30
could you give some examples
I'm sorry, just saw this now!

For example purposes, it'd be similar to a vlookup on the name, but using that specific equation which was previously determined.

For instance, Bob is male. Bob is cell A2.

His "Change #1 " column which is represented by mEquation#2 could be equal to =VLOOKUP(A2,[another table of data],3)+20*12

Sarah is female. Sasrah is cell A3.

Her "Change #1 " column which is determined to be fEquation#2 could be equal to =VLOOKUP(A3,[another table of data],5)+100/2
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,586
Office Version
365, 2016
Platform
Windows
The formulas posted earlier still work.
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Name</td><td style=";">Beginning</td><td style=";">Change #1</td><td style=";">Change #2</td><td style=";">Change #3</td><td style=";">Ending</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Bob</td><td style=";">mEquation#1</td><td style="text-align: right;;">245</td><td style=";">mEquation#3</td><td style=";">mEquation#4</td><td style=";">mEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Sarah</td><td style=";">fEquation#1</td><td style="text-align: right;;">57</td><td style=";">fEquation#3</td><td style=";">fEquation#4</td><td style=";">fEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Name</td><td style=";">Gender</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">Bob</td><td style=";">M</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">Sarah</td><td style=";">F</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">Gender</td><td style=";">Beginning</td><td style=";">Change #1</td><td style=";">Change #2</td><td style=";">Change #3</td><td style=";">Ending</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">M</td><td style=";">mEquation#1</td><td style="text-align: right;;">245</td><td style=";">mEquation#3</td><td style=";">mEquation#4</td><td style=";">mEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style=";">F</td><td style=";">fEquation#1</td><td style="text-align: right;;">57</td><td style=";">fEquation#3</td><td style=";">fEquation#4</td><td style=";">fEquation#5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style=";">bob</td><td style=";">fsa</td><td style="text-align: right;;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style=";">rick</td><td style=";">gsh</td><td style="text-align: right;;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style=";">sarah</td><td style=";">some</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:B2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:C2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:D2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:E2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A2,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A2:F2</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:B3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:C3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">D3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:D3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">E3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:E3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F3</th><td style="text-align:left">=VLOOKUP(<font color="Blue">VLOOKUP(<font color="Red">$A3,$A$11:$B$12,2,0</font>),$A$17:$F$18,COLUMNS(<font color="Red">$A3:F3</font>),0</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C17</th><td style="text-align:left">=VLOOKUP(<font color="Blue">A2,A22:C28,3</font>)+20*12</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C18</th><td style="text-align:left">=VLOOKUP(<font color="Blue">A3,A22:E29,5</font>)+100/2</td></tr></tbody></table></td></tr></table><br />
 

Forum statistics

Threads
1,081,537
Messages
5,359,380
Members
400,526
Latest member
Brook1083

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top