Hi Patric,
This formula works for your example but may not for a larger sample of data:
Formula:
=IFNA(INDEX($B$3:$B$5,MATCH(RIGHT(D3,4),RIGHT($B$3:$B$5,4),0)),INDEX($B$3:$B$5,MATCH(MID(D3,3,4),MID($B$3:$B$5,1,4),0)))
See it in the attached:
Index Match Right or Mid.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Sorry that it took me a while to get back with you. It works for the most part, but not with a vast amount of data (Like you thought might happen). See, the sheet that I'm using this formula/code for, has over 40,000 rows of data. When I use the formula you gave me on that many rows, it nearly crashes my computer. To combat this, I made sure to end all other processes on my computer and then try again with a smaller amount of data. Still nearly crashed my computer. So yeah, still in need of help here, thanks though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks