Using VBA to VLOOKUP

[Tim C]

This is a follow up to my previous post. I had made a simple function to direct VLOOKUP with the proper database name. The problem I run into in this situation is that the cell, for example this is what I had: =Database(L13) where L13 was the variable for the proper database to search, the function would work however, the cell would return the solution in text and not formula... is this a dead end or am I missing something?

Tim C

 

[DonkeyOte]

Have you tried INDIRECT using the result of the formula?

So your answer would become =INDIRECT(Database(L13))