Assuming you will only have single instances for A&B, and values always in C,
you could use SUMPRODUCT:
=SUMPRODUCT(--(A2:A100=1234),--(B2:B100=1234),(C2:C100))

Hope this helps.
--
John C


"Ali Noor" wrote:

Dear All,

Facing problem to write a proper lookup formula for following problem,

Look value in Coulmn A match it in Coulmn B and return the Number In coulmn C

where i can not array B and C and need C coulmn value as under


Column 1 Column 2 Column3 Column4

1234 1234 15 Require V look up to give 15 as
answer.


Hope to hear form all the experts soon

Thx in advance

Regards......Ali
--
Ali.