Using excel 2007, I have 2 worksheets.
The first one is 1 column of about 600 numbers/IDs.
The 2 worksheet is about 30 columns for about 5000 IDs.
Im basically trying to filter out the 600 IDs listed in to first spreadsheet from the 5000 in the second spreadsheet.
I have tried multiple Vlookups similar to this.
Where B1 is the first ID on the second spreadsheet, ids.xls contains the list of IDs im checking against and have selected all rows. then I have 1, to show the value in the 1st column for that id, the FALSE to only return if the value is exact.
I then copied this formula through the whole column, where B1, would be updated to B2, B3 etc.
But this isn't working, instead of returning the ID when it matches, the formula is returning NA, even though there is a value available.
Why is this not working? What formula can I use to check if a value matches a value from a list of values?