*Maybe* this...

Entered on the Working sheet in cell B2:

=SUMPRODUCT(--(Info!$A$1:$A$5=$A2),--(Info!$B$1:$B$5=B$1),Info!$C$1:$C$5)

Copy across then down as needed.

--
Biff
Microsoft Excel MVP


"Jayz" wrote in message
...
I have a problem that I require help on.

I am working on a big spreadsheet. I have to pull information from one
sheet
into another. However I have 2 lookups to do. Is this possible.

example - Info Sheet
A B C
1 Manchester ABC Total -230.30
2 Manchester DEF Total +123.34



Example - Working Sheet

A B C
1 Store Name ABC Total DEF Total
2 Manchester

I need to lookup "Manchester" and "ABC Total" to give me "-230.30" in a
cell.

Any Ideas if this is possible, or another solution!!

Thanks in advance

Jayz