How to use VLOOKUP for columns with indentation?

Options

Hi, I am not able to use VLOOKUP on the column which has indentation in another sheet, is there a way out I can search and match in the column with indentation

Answers