| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to lookup one source with alot of table array?
lookup value=eg.Custnum, table array= multiple spreadsheets of Custnum???
this formula is it possible to work? pls guide me |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to lookup one source with alot of table array?
Not a good description of your problem, which is probably the reason you did
not get an answer. Take a look at VLOOKUP Worksheet Formula, and since other sheets are involved you would need to use defined names. http://www.mvps.org/dmcritchie/excel/vlookup.htm That is if the information you need is on various sheets, not the customer numbers on various sheets. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Winson" wrote in message ... lookup value=eg.Custnum, table array= multiple spreadsheets of Custnum??? this formula is it possible to work? pls guide me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP VALUE OCCURS ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE | Excel Worksheet Functions | |||
| vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
| table, index, array, match, lookup? | Excel Worksheet Functions | |||
| Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
| How do I delete a lookup table array name? | Excel Worksheet Functions | |||
Linear Mode
