Populate multiple columns
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? |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com