You could join the two columns together in a third column and do the look up in that column...
=B1 & C1 would give you "ManchesterABC Total" to lookup.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"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