Sheet1!F2=IFERROR(INDEX('Imported Data'!$A$2:$A$34,SMALL(IF(ISERROR(MATCH('Imported Data'!$A$2:$A$34,Sheet1!$C$2:$C$17,0)),ROW('Import ed Data'!$A$2:$A$34)-1,""),ROW('Imported Data'!$A2)-1)),"") as array formula
You are replicate the rest for your other cells.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks for the help, much appreciated
There are two account numbers in the sample file appearing on sheet imported data and not on sheet1. However, the formula only indicates account 1130 as not appearing on sheet1, whereas account 1130 and 1131 do not appear on sheet1 (they appear on sheet imported data)
It would be appreciated if you could check the formula in the attached workbook and amend your formula accordingly
Last edited by Howardc; 04-05-2013 at 09:38 AM.
Posting Permissions
Reply With Quote
Bookmarks