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

Maybe you can use the attached.

Attached Files

Customers.xlsx (11.3 KB, 14 views)