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

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