Very clear and helpful tutorial, nice work!

@datauntelligence

2 ай бұрын

Thanks for the feedback. It's surprising how often I need to use this formula.

@kirk1968

2 ай бұрын

That is definitely a very useful one!

Very helpful, thanks for sharing

@datauntelligence

22 күн бұрын

No problem. This is a lot easier than the old index/match formula. Thanks for the comment.

Great video and example. Thank you!

@datauntelligence

2 ай бұрын

No problem. Thanks for commenting. Xlookup is my favourite function.

I wish you would get rid of the music, a bit irritating and distracting

@datauntelligence

2 ай бұрын

Hey, thanks for the comment. Feedback noted, I was trying something new.

When I try the last formula, it works until I try to add the second data set. After I close the formula, I get #VALUE. Not sure what I'm doing wrong but if it helps as all, here are the formulas I used . The one that works > =XLOOKUP([@[PART NO. COPY]],A2:A3,I2:I3) The one that doesn't work > =XLOOKUP([@[PART NO. COPY]],A2:A3,XLOOKUP([@[OP COPY]],B2:B3,I2:I3))