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 u...
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.
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.