Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question on Vlookup
I am setting up a Quality check worksheet. I have one sheet each for every supplier . These sheets contain article number for each product they supply and respective dimensions and other detials of each product. On the Quality check sheet i have article number, name of supplier and all the detials i need for the article number i select. for each detail i am using a vlookup function, where it looks up detail for the article number i have chosen. I have named ranges for each supplier sheet by the name of the supplier. I want to set up the quality sheet in such a way that once i select teh supplier name in this sheet, all the vlookup funtions in this sheet will take data from the sheet of the supplier name i selected. Hence if i had to add new suppliers later, it is included automatically. I have name the ranges for each supplier sheet by the name of supplier, so i was wondering how can vlookup take up range names automaticaly with respect to the supplier name i select in the quality sheet. If this does not work, can it be done in some other way. thanks for all help, dharmik -- dharmik ------------------------------------------------------------------------ dharmik's Profile: http://www.excelforum.com/member.php...o&userid=25463 View this thread: http://www.excelforum.com/showthread...hreadid=389037 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Question. | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
Vlookup Question | Excel Discussion (Misc queries) |