Vlookup doubt..

W

winson

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

chalky

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

Can you illustrate the issue
 
U

ufo_pilot

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