hi i got a problem that i don't know how to lookup from the main
source(e.g.CustNum) with 6 different excel xls files(e.g.CustNum).
pls guide me =(


--
winson
------------------------------------------------------------------------
winson's Profile: http://www.excelforum.com/member.php...o&userid=30587
View this thread: http://www.excelforum.com/showthread...hreadid=502361

Happy to help but i am going to need a lot more information. What are
you actually trying to do / have tried already?

Can you illustrate the issue?


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=502361

What Does VLOOKUP Do ?
In the cell you ned the result, use the VLOOKUP fuction:


=VLOOKUP(ItemToFind ,RangeToLookIn( ,ColumnToPickFrom
,SortedOrUnsorted)
The LOOKUP_VALUE is the ItemTo Find in the first column of your array (
single cell, or type in the text or number which it should look up .
TABLE_ARRAY is the Ranget to look in (use all rows and columns where data
should be located from).
COL_INDEX_NUM is the column number within the array you picked where the
result should be picked from ( how far across the table the function should
look to pick from).
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes,
FALSE for no.
HTH
If you need somethimg else, please give more specific details.


"chalky" wrote:


Happy to help but i am going to need a lot more information. What are
you actually trying to do / have tried already?

Can you illustrate the issue?


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=502361