Hi,

Is there any way to populate multiple columns with the data taken from other
workbooks using vlookup, if or index function?
I have wrkbk 1, 2 and 3 with data in 1 and 2....job number is common field
in 1 and 2. Using this job # as the reference, i am trying to get the data
for a perticular job in wrkbk 3. i am using if and index function to do this.
so, is it possible to get multiple data at once?