|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Maybe you can use the attached.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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! IF, SUMIFS, INDEX-MATCH or anything else??? | muraterguden | Excel | 6 | 01-16-2016 07:01 AM |
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 |