I have two files in excel 2007. I need to use user_id to match up from the lapsed-user file to auto add the expire_date from the am_user file into column b of the lapsed user one. I've been fighting formulas for too long now trying to get this right.
I can't attach the files because it would be public.
I use this:
And the result in the column is wrong, does not match anything in the other table. Example is row 2 of the lapsed file should show this: 8/15/2009 but instead shows 40040. Neither columns either place are set to anything different that just general. I definitely have the right column number set in the formula.