filter data

[xman_in]

i have data saved in Dump sheet of attached excel file. i want only those rows to be visible/filtered whose value for "Agent ID" colum mathces the values that i have stored in IDM sheet. please help me to get this done. i have tried using advance filter but unable to do that. you can download the data file from this link http://www.4shared.com/file/68581255/72e2ac26/Data.html
please help me, thanks in advance.

 

[DiscipleRyan]

A few problems here that may be related to how the data was imported into Excel. Your Agent ID column has leading spaces and the column is text while the values in the IDM sheet lack leading spaces and are numbers. To get around this I added a column and the very left and used the following formula to remove the leading space, convert the value to a number, and identify if the row contained an agent ID that matched the list on the IDM sheet.

=IFERROR(VLOOKUP(VALUE(SUBSTITUTE(C2,LEFT(C2),"")),IDM!$A$2:$A$21,1,FALSE),0)

Insert a column to the left of A on the "Dump" tab, then copy & paste the formula in A2 and fill down. Items with a "0" don't match. Filter out the "0" rows and you're golden. You can also replace the table array with a named range if the list on the IDM tab will vary regularly.

Anyone else have any ideas?