Formula for Fetch Data from another sheet

Closed
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Apr 19, 2016 at 01:43 PM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Apr 19, 2016 at 02:59 PM
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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 19, 2016 at 02:22 PM
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 September 5, 2015 Status Member Last seen March 8, 2017 1
Apr 19, 2016 at 02:59 PM
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
0