Vlookup doubt..

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 =(

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?

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
>
>