please help.
Example -- I have a sample in Sheet1 that is incomplete. I want to look in sheet2 column B and display the results of all partial match in column B, column C, Column D....... of sheet1
i was able to get only one result when i used vlookup but do not know how to get the rest to display
You could use this array formula:
=IFERROR(INDEX(Sheet2!$B:$B,SMALL(IF(ISNUMBER(FIND(Sheet1!$A2,Sheet2!$A$2:$A$10)),ROW(Sheet2!$A$2:$A$10)),COLUMNS($B2:B2))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks Glenn!!! Worked perfectly
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks