troubleshooting Question

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

Avatar of Heather Ritchey
Heather RitcheyFlag for United States of America asked on
Microsoft ExcelMicrosoft OfficeSpreadsheets
9 Comments1 Solution110 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Glenn Ray
US Data Team Lead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2014

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 9 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 9 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004