Forum Discussion
Solved
function help
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.
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.
1 Reply
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.