Hi all

I need some help with formulas please.

Here's what I need:-

I need a formula that will lookup and match 2 criteria from a different
worksheet (however the cells on that worksheet are constantly moving row
numbers so I cannot reference it to one cell) and then return a value on
the same row but in antoher column.

Have tried this formula but not working properly!!

{=(SUM(IF((L:Z=C11)*(N85:Y85=I6),L95:Y95)))}

What am I doing wrong or can anyone provide a solution??

Be very grateful for any help please!!

Thanks
;)


--
certain_death
------------------------------------------------------------------------
certain_death's Profile: http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=381524