J jennifer New Member Jun 4, 2014 #1 Is their a way to write a vlookup formula that will go to a drop down cell and get that name and go to the respective tab and pull data?
Is their a way to write a vlookup formula that will go to a drop down cell and get that name and go to the respective tab and pull data?
Luke M Excel Ninja Staff member Jun 4, 2014 #2 Yes, you could use the INDIRECT function. Let's say the dropdown with sheet names is in A1. Formula would be something like: =VLOOKUP(A2,INDIRECT("'" & A1 & "'!A:E"),5,FALSE)
Yes, you could use the INDIRECT function. Let's say the dropdown with sheet names is in A1. Formula would be something like: =VLOOKUP(A2,INDIRECT("'" & A1 & "'!A:E"),5,FALSE)
