Hi all,
I’m learning excel, and still quite new to writing formulas, so forgive me if this a stupid question. I’m just having no luck and my knowledge is limited.
I have a task that requires me to pull a grade code using an employee number from one worksheet and including it into another worksheet.
I’m trying to use an xlookup, by using the employee number from as my lookup array, the grade code as my return array and my result is 0. I was getting an error so hopefully I’m heading in the right direction.
formula: =xlookup([level],sheet2!g:g,sheet2!j:j,na,0)
I feel like maybe I need an if statement? But the xlookup wouldn’t allow it. Any help is greatly appreciated!
I’m learning excel, and still quite new to writing formulas, so forgive me if this a stupid question. I’m just having no luck and my knowledge is limited.
I have a task that requires me to pull a grade code using an employee number from one worksheet and including it into another worksheet.
I’m trying to use an xlookup, by using the employee number from as my lookup array, the grade code as my return array and my result is 0. I was getting an error so hopefully I’m heading in the right direction.
formula: =xlookup([level],sheet2!g:g,sheet2!j:j,na,0)
I feel like maybe I need an if statement? But the xlookup wouldn’t allow it. Any help is greatly appreciated!