Home | Forums | Galleries | Twitter
 
CPFC BBS  

Go Back   CPFC BBS Off Topic Computers, Gaming and Mobile Forum

Notices

Computers, Gaming and Mobile Forum All things computer, internet, mobile, tablet and video game related.

Reply
 
Thread Tools
  #1  
Old 21-01-2016, 09:34 AM
chatham_eagle's Avatar
chatham_eagle chatham_eagle is offline
Mind your sandwiches
 
Join Date: Jun 2007
Location: Caterham
Age: 30
Posts: 19,477
Rep Power: 21474848
chatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is herechatham_eagle Sam the man is here
Excel help #2389

I have one spreadsheet which contains c 500 account numbers. I want to populate this with data from another spreadsheet, which contains c50000 account numbers and various other info (addresses etc). I only want the data for the 500 accounts.

Is there any way to do this?

I've tried doing a VLOOKUP but it doesn't seem to work.

TIA.
__________________
Mine is a faith in my fellow man.
Reply With Quote
  #2  
Old 21-01-2016, 09:37 AM
Shamone's Avatar
Shamone Shamone is offline
Shit or Bust
 
Join Date: Jun 2004
Age: 37
Posts: 3,341
Rep Power: 17980981
Shamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy dietShamone came here looking for the peace and quiet; the healthy air and the healthy diet
Vlookup. Find out why Vlookup isn't working. Send me a sample if you want and I'll look at it.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:32 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.