Hello,
I have data with a description in one column and an ID in another.
Is it possible to take the ID and the end letter of the description and look up the description?
I enclose and example.
Hello,
I have data with a description in one column and an ID in another.
Is it possible to take the ID and the end letter of the description and look up the description?
I enclose and example.
you can do it with this index/match, BUT this is an array formula so it needs to be activated using ctrl/shift/return so that {} appear on each end, YOU CANNOT add them to the formula. It will look like this when properly activated.
{=INDEX($A$2:$A$11,(MATCH(I2&J2,$B$2:$B$11&RIGHT($A$2:$A$11,1),0)))}
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you. Just what I was looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks