Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a worksheet
I want to be able to type in a name in 1 cell and another name in another
cell and then it give me a number... example C7= BTGH F7= HH and the result is 3 this is for a mileage expense report that we just want to be able to type in the locations of each and then it gives us back the mileage amounts. sometimes the information may be... C7 = HH F7=BTGH and the result is still 3 there are a lot of other locations that need to be added, i think i just need help starting ... thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a worksheet
You need a VLOOKUP() table. For example in columns AB and AB and AC and AD:
In AA the start In AB the destination In AC the formula: =AA1 & AB1 In AD the mileage For example: London Paris LondonParis 20 Paris London ParisLondon 20 London Madrid LondonMadrid 30 Madrid London MadridLondon 30 then =VLOOKUP(C7 & F7,$AC$1:$AD$20,2) will lookup the mileage from the table. -- Gary''s Student - gsnu200755 "Setting a Mileage Expense Report" wrote: I want to be able to type in a name in 1 cell and another name in another cell and then it give me a number... example C7= BTGH F7= HH and the result is 3 this is for a mileage expense report that we just want to be able to type in the locations of each and then it gives us back the mileage amounts. sometimes the information may be... C7 = HH F7=BTGH and the result is still 3 there are a lot of other locations that need to be added, i think i just need help starting ... thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up Excel worksheet | Setting up and Configuration of Excel | |||
Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
Setting up a worksheet for LOG LOG analysis | Excel Worksheet Functions | |||
Novice needs help setting up a worksheet | New Users to Excel | |||
Help with setting up a worksheet funtion | Excel Worksheet Functions |