I want to use the same table but use one column if tax filing status is 'married' and another column if the tax fling status is 'single' then depending on the state selected and tax filing status, then it would be determined on income range.... Yikes Help!
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))
Great video and example. Thank you!
No problem. Thanks for commenting. Xlookup is my favourite function.
Very clear and helpful tutorial, nice work!
Thanks for the feedback. It's surprising how often I need to use this formula.
That is definitely a very useful one!
Very helpful, thanks for sharing
No problem. This is a lot easier than the old index/match formula. Thanks for the comment.
I want to use the same table but use one column if tax filing status is 'married' and another column if the tax fling status is 'single' then depending on the state selected and tax filing status, then it would be determined on income range.... Yikes Help!
might be easier if we jump on a zoom so i can show you
I wish you would get rid of the music, a bit irritating and distracting
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))