Excel VLOOKUP with INDIRECT

[@mukeshgupta4143]

I was looking this function with similar example of my query... Awesome...

[@ashvids]

🔥

[@ApexTrainingLLC]

Thank you!

[@hurimaamiyeva4052]

Hi, im trying this task but my table is other sheets, how can i solve this? Sorry my bad English))

[@ApexTrainingLLC]

You just have to include the sheet name with the address... sheetname!a1

[@ApexTrainingLLC]

That will happen automatically if you select the range in the other sheet with your mouse.

[@sandeepkumar-cx4or]

Thanks a lot

[@gerardvaneggermond9967]

hello, maybe you can help me if i want to search the list in a range, for example "E4: F23" of which in row F, excel succeeds by making an extra vertical search, now my question is I also do this in a list, or how do I work around this problem? Can you help me, if you want more info ask?

[@ApexTrainingLLC]

Hi Gerard. I'm not sure I understand the question. Can you give me some more details, or send a copy of your spreadsheet? [e-mail]

[@mukeshgupta4143]

Great thank you sir.

[@ApexTrainingLLC]

Mukesh Gupta Thank you for the feedback!

[@pradeeprastogi3777]

Mukesh bhai, i am Pradeep, i tried to use this but could not get success. Could you please help me to get it done. Regards Pradeep

[@กุญชรบ่อน้อย]

I tried several times. But not me.

[@ApexTrainingLLC]

กุญชร บ่อน้อย hi... Can you tell me more about what problem you had?

[@กุญชรบ่อน้อย]

I tried Excel formula VLOOKUP with INDIRECT based on your video every step. But not successful.

[@ApexTrainingLLC]

do you want to send me a copy of your spreadsheet? I'm happy to take a look at it. [e-mail]

[@กุญชรบ่อน้อย]

I will send you a file for you.

[@kirandeepchoudhry9232]

First you have to give name for each table and then use it.Might it work

[@usmaniqbal1836]

Sr, plz share this Excel File....