Sheet Reference as we type in vlookup

[bharath]

Hi,

I just got one thought of if sheet reference as we type sheet name in particular column, it should be taken as range/reference in vlookup formula or any.
If it is possible in excel by not using macros, we will be great full to you.

I am enclosing the sample excel file

 

[rahulshewale1]

Hi @bharath,

Cell D2 Formula Copy Down,

=VLOOKUP(C2,INDIRECT(B2&"!C:D"),2,FALSE)

 

[bharath]

yes, its working
thank you rahul ji