Assume table one is in a sheet: X, data in cols A to C from row2 down
table two is in a sheet: Y, data in cols A to C from row2 down to say row1000

In X,

Put in D2, array-enter (press CTRL+SHIFT+ENTER):
=INDEX(Y!$C$2:$C$1000,MATCH(1,(SUBSTITUTE(Y!$A$2:$A$1000,"D","")=A2)*(Y!$B$2:$B$1000=B2),0))
Copy D2 down as far as required

Adapt the ranges to suit. Use the smallest range size sufficient to cover
the max expected extent of data in Y.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ross" wrote:
> I have a table of data that has dates, production lines and production
> volumes (table one):
>
> Production Line Date Volume
> A02 13/3/06 189
> C32 13/3/06 325
> T12 14/3/06 21
>
>
> The table contains data retrieved from the beginning of the year so there is
> a substantial amount, I have on a separate sheet a list of further data
> (table two):
>
> Production Line Date Tank
> AD02 13/3/06 A
> CD32 13/3/06 C
> TD12 14/3/06 B
>
>
> I want to use a formula that references two cells ( Production line and date
> in the first table) and returns from the second table the tank that the
> particular line was flowing into on that date.
> You will also notice an additional problem between the two table is that
> table one Production Line reads "A02" and table two's Production Line reads
> "AD02" so obviously this formula will have to ignore the additional D.
>
> Someone has suggested an array formula but seeing as I am using this formula
> possible several thousand times on one sheet it is slowing the whole workbook
> down far too much.
>
> Thanks for any help in advance.
>
> P