Table lookup
 

Hi Everyone,

I am trying to do a simply lookup table, but its been years since i have
done it and can't remember.
i want the excel to give me a dropdown of tariffs and it fills in the
customer price adn company GP? it sounds simple but i can not get it working.

Thanks in advance

Table lookup
 

have a table with tariffs price and GP

Do a Data - Validation using the tariffs as your drop-down

in your cell to the right =VLOOKUP(Tariff cell,Table range,2,0)

and the same further right except =VLOOKUP(Tariff cell,Table range,3,0)

Can make it nicer if you include an IF

=IF(ISNA(VLOOKUP(Tariff cell,Table range,2,0)),"",VLOOKUP(Tariff cell,Table
range,2,0))

to show a null vlaue if the VLOOKUP is blank.

"Richard" wrote:

Hi Everyone,

I am trying to do a simply lookup table, but its been years since i have
done it and can't remember.
i want the excel to give me a dropdown of tariffs and it fills in the
customer price adn company GP? it sounds simple but i can not get it working.

Thanks in advance

Table lookup
 

See these:

How to setup a lookup table:

http://contextures.com/xlFunctions02.html

How to setup a drop down list:

http://contextures.com/xlVideos07.html#DataVal01

--
Biff
Microsoft Excel MVP


"Richard" <Richard @discussions.microsoft.com wrote in message
...
Hi Everyone,

I am trying to do a simply lookup table, but its been years since i have
done it and can't remember.
i want the excel to give me a dropdown of tariffs and it fills in the
customer price adn company GP? it sounds simple but i can not get it
working.

Thanks in advance

Table lookup
 

If you are looking to create a drop down list to choose from select the cell
or cells where the validation needs to take place. Go to Data - Vaidation -
Settings. Change Allow to List and then select the list you wannt to use

"T. Valko" wrote:

See these:

How to setup a lookup table:

http://contextures.com/xlFunctions02.html

How to setup a drop down list:

http://contextures.com/xlVideos07.html#DataVal01

--
Biff
Microsoft Excel MVP


"Richard" <Richard @discussions.microsoft.com wrote in message
...
Hi Everyone,

I am trying to do a simply lookup table, but its been years since i have
done it and can't remember.
i want the excel to give me a dropdown of tariffs and it fills in the
customer price adn company GP? it sounds simple but i can not get it
working.

Thanks in advance