#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default VLOOKUP formulas

I am trying to create a VLOOKUP formula using data from a drop down list.
My goal is to have the user select an item from the list and certain item
specific variables are filled in from a table. Can anyone help me.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 247
Default VLOOKUP formulas

this link may help
http://www.contextures.com/xlDataVal02.html
otherwise post an example of what you have and what you want to acheive
--
paul

remove nospam for email addy!



"Donna" wrote:

I am trying to create a VLOOKUP formula using data from a drop down list.
My goal is to have the user select an item from the list and certain item
specific variables are filled in from a table. Can anyone help me.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 91
Default VLOOKUP formulas


when In excel check out the help index and choose vlookup
the excel help, will help alot and you can use the function wizard as
well...........

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 247
Default VLOOKUP formulas

i may have misread your message
say you have a drop down list which returns your item selected in A1
you have your table of data in a10:C20
in say A2 type =vlookup(a1,A10:C20,2,false)&" "&vlookup(A1,A10:c30,3,false)
this formula assumes that you have a table in a10:c30 in which the items in
colA are the same items in your list.The false argument means vlookup will
only return an exact match,and by combining two lookup formulas you will get
the item fron col b and colc in the same row as your matching item.
ie lookup green from list
in your table green is column a grass is col b and red is col c
the above formula will return grass red
--
paul

remove nospam for email addy!



"paul" wrote:

this link may help
http://www.contextures.com/xlDataVal02.html
otherwise post an example of what you have and what you want to acheive
--
paul

remove nospam for email addy!



"Donna" wrote:

I am trying to create a VLOOKUP formula using data from a drop down list.
My goal is to have the user select an item from the list and certain item
specific variables are filled in from a table. Can anyone help me.



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default VLOOKUP formulas

thank you for your reply.

"damorrison" wrote in message
oups.com...

when In excel check out the help index and choose vlookup
the excel help, will help alot and you can use the function wizard as
well...........



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating references to tabs in formulas proper Excel Discussion (Misc queries) 4 April 5th 06 07:54 PM
Formulas not recognizing new data malakingaso Excel Discussion (Misc queries) 1 February 8th 06 08:27 PM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
locking formulas?? Rob Excel Discussion (Misc queries) 1 July 27th 05 09:27 AM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 06:22 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"