Looking for an amount with a referance number

[djfatboyfats]

I have a work book with multible tabs, these all have referance numbers on them with an amount, what i want to do it is look down column a in all 10 tabs then look down column f for the amount, if it matches the referance number i have it will produce me the amount paid, i know how to do this for one tab but not mutiple tabs, below is the formula for one tab

Please Login or Register  to view this content.

the tab names i have are AYA,ALB,CME,DAT,DNN,NMO,PBO,ROC,SEA,SGR,TIL

Thanks in advance

DJ

[NBVC]

First List the Tab names on one of the sheets and name the list through Insert|Name|Define. Call the list TabNames and then try this formula:

Please Login or Register  to view this content.

[djfatboyfats]

Thanks this is great, thank you very much

DJ