Multiple if

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
lubumbashi 356
kitwe 320
kasumbalesa 356
lusaka 325
ndola 300
kipushi 425
zambia 325

those are road toll fees for those country

formula on any cell to read b6 and plug the exact road toll

I have done this but dont recall how i did it
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,615
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Is this what you want?

<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 /></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></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">ndola</td><td style="text-align: right;;">300</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></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></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></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">lubumbashi</td><td style="text-align: right;;">356</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style=";">kitwe</td><td style="text-align: right;;">320</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style=";">kasumbalesa</td><td style="text-align: right;;">356</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style=";">lusaka</td><td style="text-align: right;;">325</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style=";">ndola</td><td style="text-align: right;;">300</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style=";">kipushi</td><td style="text-align: right;;">425</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style=";">zambia</td><td style="text-align: right;;">325</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)">Sheet2</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)">B6</th><td style="text-align:left">=VLOOKUP(<font color="Blue">A6,A10:B16,2,0</font>)</td></tr></tbody></table></td></tr></table><br />
 

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
This will do , what will be the formula look like if without table , one line formula
 

Watch MrExcel Video

Forum statistics

Threads
1,119,249
Messages
5,576,948
Members
412,753
Latest member
Coach_Olson
Top