anyone knows how to do the following.
i have in 1 directory 200 xls files with article numbers and description and in the other directory i have 3 files with multiple sheets in each file with the same article numbersbut with a extra column called group number
i want to make a vertical lookup so that in each of the 200 files in column d comes the value which has to be found found in one of the three files
(so the search has to be done in three files
on each of the available sheets)
is this possible??
i have in 1 directory 200 xls files with article numbers and description and in the other directory i have 3 files with multiple sheets in each file with the same article numbersbut with a extra column called group number
i want to make a vertical lookup so that in each of the 200 files in column d comes the value which has to be found found in one of the three files
(so the search has to be done in three files
on each of the available sheets)
is this possible??