# Returning Intersecting Values

#### d_parker

##### New Member
We are keeping a time sheet for our employees in the following format

 Date Customer1 Customer2 Customer3 9/1/14 1 9/2/14 .5 .5 9/3/14 .75 .25

<tbody>
</tbody>

Even though it's a breeze for employees to track their time, the business office finds this format hard to read - I'd like to create a second sheet pulling data from the first that auto-fills in the following format

 A B C D E 1 Date Customer % Day Worked Customer % Day worked 2 9/1/14 Customer1 1 3 9/2/14 Customer2 .5 Customer3 .5 4 9/3/14 Customer1 .75 Customer2 .25

<tbody>
</tbody>

I'm having difficulty with all the statements to avoid printing empty cells but still pulling populated intersecting data into B2:E4

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Comfy

##### Well-known Member
May I suggest something different?

Ask you employees to complete the timesheet but use the following format.

Date ¦ Customer ¦ Time

Excel 2010
ABC
1DateCustomerTime
201/09/2014Customer11
302/09/2014Customer20.5
402/09/2014Customer30.5
503/09/2014Customer10.75
603/09/2014Customer20.25
Sheet1

This would make formatting and reporting on the data very easy.

#### d_parker

##### New Member
That would be very easy - but no offense, there are reasons i asked for, what i asked for.

Replies
2
Views
243
Replies
18
Views
533
Replies
5
Views
490
Replies
4
Views
334
Replies
3
Views
1K

1,190,898
Messages
5,983,467
Members
439,843
Latest member
PlanetFitness

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back