I want to use Vlookup function in excel. but i want to pass sheet name as parameter, i want it dynamic?

Question

I have one sheet in which i want to design macro that will use Vlookup function to get data from other sheets. but the problem is i want to pass sheet name as parameter coz i have to refer different sheets, i want that when i run a macro it ask for sheet name and depending on sheet name it should fetch data from that sheet into current sheet.

Answer 1

Believe it or not

YOU CAN DO THIS USING FORMULA ONLY

You can use VLOOKUP with ADDRESS and INDIRECT functions to work all together to get what you want

That is an option
Another option is to use Name (From Insert > Name > Define) to define a dynamic name based on a cell value

Both methods need to send you a file to show how to do it

If you are interesting, I can manage to spare some minutes to do it for you.
I just need your e-mail address to send you the file

Anyway, you can always trust, I am the VBAXLMan here

Answer 2

link below