LinkBack URL
About LinkBacks
Hi,
a first approach could be
Formula:
=index(data(b$2:b$1000,match(left(b1,find(" ",b1)-1),data!a$2:a$1000,0))
A sample file could be helpful to adjust formula references
Hi,
a first approach could be
Formula:=index(data(b$2:b$1000,match(left(b1,find(" ",b1)-1),data!a$2:a$1000,0))
A sample file could be helpful to adjust formula references
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks