RE: Vook up help required

From: John C <johnc@stateofdenial>
Date: Mon, 13 Oct 2008 08:51:33 -0700

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.

Follow-Ups:
- RE: Vook up help required
  - From: Ali Noor

References:
- Vook up help required
  - From: Ali Noor

Prev by Date: Nested Functions Help
Next by Date: RE: How to extract text when it's included in the format?
Previous by thread: Vook up help required
Next by thread: RE: Vook up help required
Index(es):
- Date
- Thread

Relevant Pages

RE: Vook up help required
... "Ali Noor" wrote: ... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... "Ali Noor" wrote: ... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... "John C" wrote: ... "Ali Noor" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... column is equal to 1234 (or whatever cell reference you are using), ... "John C" wrote: ... 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 ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... "John C" wrote: ... 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 ... Thx in advance ...
(microsoft.public.excel.worksheet.functions)