Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List + VLOOKUP
Hi, let me just explain whats the situation =)
i have a supplier detail table, where there are supplier's name, address, fax no. and telephone no. i made a stock order list. Ok, now i need something like a drop down list where i can select the suppliers names... so e.g. in the SDT the supliers are, AA, BB, CC, i would want the drop down list to have dat, which i did. Now what i need and i dont know how to make it, when i select AA (from the drop down list) i need the cell below it to return the fax number bak. i tried using VLOOKUP but i think i did it wrong =( pls help, if you need any other info pls tell me =) thx in advance Bonbon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List + VLOOKUP
dont worry ppl i did it =)
"Bonbon" wrote: Hi, let me just explain whats the situation =) i have a supplier detail table, where there are supplier's name, address, fax no. and telephone no. i made a stock order list. Ok, now i need something like a drop down list where i can select the suppliers names... so e.g. in the SDT the supliers are, AA, BB, CC, i would want the drop down list to have dat, which i did. Now what i need and i dont know how to make it, when i select AA (from the drop down list) i need the cell below it to return the fax number bak. i tried using VLOOKUP but i think i did it wrong =( pls help, if you need any other info pls tell me =) thx in advance Bonbon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Unique drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |