I am trying to make a formula that may need LOOKUP,INDEX and MATCH functions.

We agree but that's why rules say: Your post title should accurately and concisely describe your problem, not your anticipated solution. so you can easily give appropiate title (without knowing what formula will be used... Mostly, a solution is far opposite than you imagine at the first time)...

(just imagine what would someone else write in search box to find your thread)