N nadjalil Member May 9, 2015 #1 dear all i want to redirect column number in vlookup formula attached is my workring where i need it... thanks for your help. Attachments Indirect function use for Columns in Vlookup.xlsx 10.4 KB · Views: 0
dear all i want to redirect column number in vlookup formula attached is my workring where i need it... thanks for your help.
N NARAYANK991 Excel Ninja May 9, 2015 #2 Hi , See if this is OK. Narayan Attachments Indirect function use for Columns in Vlookup.xlsx 12.7 KB · Views: 2
Deepak Excel Ninja May 9, 2015 #3 Check this.. Attachments Indirect function use for Columns in Vlookup.xlsx 10.1 KB · Views: 0
Deepak Excel Ninja May 9, 2015 #4 One more.. =INDEX(Sheet2!$B$1:$N$5,MATCH(B3,Sheet2!$B$1:$B$5,0),MATCH($C$1,Sheet2!$B$1:$N$1,0))
N nadjalil Member May 9, 2015 #5 Thanks for all of you for your quick replies, first one is working fine with me.... thanks a lot