function help

[Krishck]

Hi,

I am new to excel as I am learning to understand the usage and different ways on working on the data. I am attaching a sample sheet, which consists of two worksheets. I am looking for a way to use the level from worksheet named "Level" and bring that to test_data in yellow field. So that the formula can be copied all the way down easily, rather than bringing from another worksheet.

Can anyone help me out with a easy way? Thank you. 

[#2 · Accepted solution]

@Krishck That could be, in O2

=XLOOKUP(N2,Level!B:B,Level!C:C,,0)

or, if you prefer to use "good old" VLOOKUP, try this

=VLOOKUP(N2,Level!B:C,2,0)

 and copy it all the way down.