Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2017, 09:51 AM
robertjohn81 robertjohn81 is offline Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Windows 10 Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Office 2007
Novice
Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another
 
Join Date: Jan 2017
Posts: 1
robertjohn81 is on a distinguished road
Default Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another

Hi there folks,

I'm hoping your combined knowledge may be able to help me with this problem ....
I've a decent understanding of what I want to do - just not sure how to construct the formula in excel ....

I run my own small business and I have a single excel sheet with each of my customers listed in one column and their phone numbers in the second, and subsequent details in the additional columns.

On a seperate sheet, I have a running record of the work carried out each day.

What i would like to be able to do is have a forumla, that whan I type a customers name in cell A1 - it would look through the customer list on the other sheet, and on finding the relevant customer - automatically fill the additional date for that customer in B1, C1, D1 etc.

From my admittedly limited understanding, i think the Vlookup or index/match functions may be appropriate, but i'm wondering then, how do i work the condition into it, that the data is only pulled on a true value for the match ??

Any help would be greatly appreciated.

Rob
Reply With Quote
  #2  
Old 01-19-2017, 11:20 AM
xor xor is offline Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Windows 10 Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe you can use the attached.
Attached Files
File Type: xlsx Customers.xlsx (11.3 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match krispykreme Excel Programming 1 09-09-2016 11:25 AM
Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another Help needed! IF, SUMIFS, INDEX-MATCH or anything else??? muraterguden Excel 6 01-16-2016 07:01 AM
Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another How to compare two columns and match data Neydo222 Excel 2 09-12-2015 02:49 AM
Methods to pull data from another sheet using drop down list fajl Excel 0 07-19-2014 12:31 AM
Complex Formula using INDEX and Match needed OTPM Excel 5 05-23-2013 01:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft