lookup

[Mimo_2020]

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

[#2 · Accepted solution]

Hi @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.

https://youtu.be/ROym3e-S4OQ

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

[#3]

@Faraz Shaikh 

Thanks alot this was just what i was looking for. 

[#4]

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