Avatar of Heather Ritchey
Heather RitcheyFlag for United States of America

asked on 

I just need someone to get this one column into another workbook in excel.

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:
=VLOOKUP(A:A,am_access.xlsx!$D:$H,5,FALSE)

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.
Microsoft ExcelMicrosoft OfficeSpreadsheets

Avatar of undefined
Last Comment
Glenn Ray
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Your VLOOKUP formula is working; you just need to format the cell with the formula to show a date.  40040 is the internal value for August 15, 2009.

However, I don't think A:A is correct; that should just be a single cell reference (ex., A2).

Regards,
Glenn
Avatar of Heather Ritchey

ASKER

Glenn, Is there a way to show you the files so they're not public?  One has md5 pw's, so I can't even show a screenshot.
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

You could email them to me directly, but I believe that is against EE policy (someone correct me if I'm wrong).

I usually recommend redacting sensitive content and leaving just the values in question.  Or create a replica.
Avatar of Heather Ritchey

ASKER

I'm afraid if I change things and have to change back I'll make it worse ;) That's what I thought too on policy, but if you want to chance it - shoot me an email quick to h at dzynit.net and I'll send the files to you. As long as we post back the ultimate solution, I don't see what it's hurting.
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

That's why it's a good idea to keep backups! :-)

I'll see what I can do.
Avatar of Heather Ritchey

ASKER

I have backups, I'm just afraid I'll muff the files up if I remove what should not be public then have to put it back ;) I obviously really suck at excel!
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Heather Ritchey

ASKER

You are awesome Glenn!! Thank you sooooo much!!
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

You're welcome.  You were really close to the solution on this.
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo