Hi to all,
I have two sheets having data, in one data sheet having 1200 rows and 1000 columns data. I have lookup values in another sheet containing same 1200 rows as in first sheet. Now i want to get data for these lookup values (columns data) . Now i am using this vlookup formula
=VLOOKUP(C2,'excelrange'!$D$5:$D$342,1,FALSE)
Now i am getting data from 1 column, i want to get data from other columns (2 to 1000) by dragging my formula but i donot like to change column number always for every coulmn and i want to fix this for both rows and cloumns.
Can any one help to solve my problem?
any help would be appreciated
Thanks in advance
Regards,
Genetist
Bookmarks