Hi I am trying to use a cell and enter a number that will be used as a reference instead of hard coding the number I formula below as Col_index_num.
.
=IF(B598="",Q598,VLOOKUP(B598,INDIRECT("'["&G598&".xlsx"&"]"&H598&"'!"&"$A:$AE"),8,0))
What syntax should I use?
Thanks.
Simply replace 8 in the formula with the cell reference that contains a number in it.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
With the INDIRECT function you don't need the absolute reference so this will suffice:Formula:
Please Login or Register to view this content.
As for the column index number, simply replace the 8 with the cell reference, so if the number was in H1 try:I made the row absolute as I am assuming you will be dragging the formula down without wanting to change the column index number.Formula:Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Thanks for that. I think it didn't work before because I didn't have both files open.
Yes, if using the INDIRECT function to build a reference to another file that file must be open for the formula to work properly.Originally Posted by Bobz1983
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks