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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

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,114,528
Messages
5,548,576
Members
410,852
Latest member
WernerS
Top