Hi, all. I'm trying to do the same thing: I have a two lists of numbers in Columns D & E, Rows 2 thru 163. My formula in F2 is =MATCH(D2,$E$2:$E$163,0). I copied this down Column F thru Row 163. It *appears* to work, in that cells in Column F are populated with correct row numbers for most matches, however where it returns #N/A, (which should indicate that the value in the corresponding cell in Column D is not found in Column E, right?) I can see that it is wrong - at least some of those values ARE found within the specified range in Column E. What am I missing or doing wrong??
Thanks!