Lookup value

[rahulshewale1]

Dear Respected sir,

there are two sheet one is Data sheet and second is formula sheet i want formula in Formula sheet.i want lookup value.

 

[xlstime]

What's the issue here? you can use simple vlookup or please explain your query.

Dear Respected sir,

there are two sheet one is Data sheet and second is formula sheet i want formula in Formula sheet.i want lookup value.

 

[rahulshewale1]

Dear sir,

there are multiple sheet in Data sheet .in formula sheet i want formula if i am change B2 date lookup will be change.

 

[xlstime]

Please refer enclosed, have merged both sheets.

you can modify little formula for split workbook (multiple)

=VLOOKUP($B4,INDIRECT("'C:\Users\xyz\Downloads\[Data sheet.xlsx]"&$B$2&"'!$B$4:$H$12"),2,0)

Just change highlighted one with your file location

Dear sir,

there are multiple sheet in Data sheet .in formula sheet i want formula if i am change B2 date lookup will be change.

 

[shrivallabha]

Please refer enclosed, have merged both sheets.

you can modify little formula for split workbook (multiple)

=VLOOKUP($B4,INDIRECT("'C:\Users\xyz\Downloads\[Data sheet.xlsx]"&$B$2&"'!$B$4:$H$12"),2,0)

Just change highlighted one with your file location

Can you test your solution keeping the source file(bold part) closed?