Formula for Fetch Data from another sheet

Closed
smuneeb Posts 67 Registration date Saturday 5 September 2015 Status Member Last seen 8 March 2017 - 19 Apr 2016 à 13:43
smuneeb Posts 67 Registration date Saturday 5 September 2015 Status Member Last seen 8 March 2017 - 19 Apr 2016 à 14:59
Hello,

First I would like to asked that how could I insert a excel file or create a link, to understand my query.
because the query that I want to asked cannot only be solved by VLOOKUP OR HLOOKUP but it may also be required INDEX or MATCH or LOOKUP Functions.


Thanks

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
19 Apr 2016 à 14:22
smuneeb, Good afternoon.

Save your file at a free site www.speedyshare.com and put a link to download here.
smuneeb Posts 67 Registration date Saturday 5 September 2015 Status Member Last seen 8 March 2017 1
19 Apr 2016 à 14:59
Hi Mazzaropi

Thanks for guidance Uploading a File

Please click the link below for understanding my query

http://speedy.sh/g4msV/Fecth-Data-from-another-Sheet.xlsm

Now my Query is that if I want to enter date in Sheet1 Date and Day Column C11 and onwards
then How could the data is fetch to Sheet2 in DoE Column
Note that Unique Identity must be consider Course No which is given to both sheets

Thanks & Regards