Excel compare a columns between two sheets (sheet A and Sheet B), copy data from a cell in sheet B to a cell in sheet A

I had to compare data between two different sheets, then fetch the data from a specific cell in sheet B and copy it to another cell in Sheet A.

I used the following formula -

=INDEX(Sheet2!$H$1:$H$1227,MATCH(Sheet1!B2,Sheet2!$B$1:$B$1227),0)

Where

• INDEX (Sheet2!$H$1:$H$1227 specific matching the cell from sheet B which has to be copied over
• MATCH(Sheet1!B2 It was the specific cell in Sheet A that i compared with a specific range of Sheet B
• ,Sheet2!$B$1:$B$1227)) Is the cell range in sheet B, where I performed the lookup for the specific column from Sheet A