Getting the value from similar reference

[ezraluandre]

Hi I want to get a value from one sheet to other. The problem is what I want to search is ex."Interest rate" and on the other sheet Interest Expense (Income) - Net Operating. I'm trying using vlookup and index&match but the result is not correct. How can I extract value from the other sheet when the reference name is not the same if the vlookup and index&match function doesn't work, is there other function that I can use?

[FDibbins]

If the criteria dont match (at all), then how would expect to return anything? If there is at least some matching text, you could probably use wildcards. Something like...
=match("*"&A2&"*",range,o)

However, if you have a mis-matched text (Interest rate vs Interest blah blah), then you will need to decide what part of the criteria you need to use, and then just extract that part for the search.

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.