<div>
If this is complex, it may be easier for us to help if you can use Attach File to add a sample of your data?
</div>


If this is complex, it may be easier for us to help if you can use Attach File to add a sample of your data?

TrickyLookupQ28361051x.xlsx

<div>
Thanks for the feedback much appreciated.
</div>


Thanks for the feedback much appreciated.

<div>
<div class="content wysiwyg-content">
Hi Experts excel 2007<br />
<br />
I need to look up based on staff id when member of staff was contacted. <br />
And insert results as shown into table b.<br />
<br />
Assume table A pivot table...sample date total date set 20000 staff id's<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col b<br />
Dates row 1. 12/01/2014. &nbsp; &nbsp; &nbsp;13/01/2014<br />
col A <br />
3456. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
1234. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
5678. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
9890. <br />
<br />
The number 1 shows as a count that person was called only once on that date..<br />
<br />
Table B<br />
Col e. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Col f. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Col g. <br />
3456. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/01/2014. &nbsp; &nbsp; 13/01/2014<br />
Etc...
</div>
</div>


Hi Experts excel 2007

I need to look up based on staff id when member of staff was contacted. 
And insert results as shown into table b.

Assume table A pivot table...sample date total date set 20000 staff id's
                           Col b
Dates row 1. 12/01/2014.      13/01/2014
col A 
3456.                       1.                           1
1234.                       1
5678.                                                      1
9890. 

The number 1 shows as a count that person was called only once on that date..

Table B
Col e.           Col f.                    Col g. 
3456.           12/01/2014.     13/01/2014
Etc...

tricky lookup formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.