Aug 19 2020 01:21 AM
Hi
I am working on a data sheet where data is collected and compared to date, using LLookup.
I refer to 3 different tables but do it many times, is there a way in which I can enter the table name somewhere and there after referring from this ?
So I do not have to manually change the table name in all LLookup formulas ?
Mimo
Aug 19 2020 03:35 AM
SolutionHi @Mimo_2020
You can use VLOOKUP with INDIRECT function, your lookup range will be dynamic based on the table name.. check the below video link that might be helpful.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more
Aug 20 2020 04:35 AM
Hi @Mimo_2020
Awesome :thumbs_up:, Glad to hear your query was resolved
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more
Aug 19 2020 03:35 AM
SolutionHi @Mimo_2020
You can use VLOOKUP with INDIRECT function, your lookup range will be dynamic based on the table name.. check the below video link that might be helpful.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more