RE: Vook up help required

Your ranges must all be the same length. If your values start in row 1, then
modify the formula as needed. My understanding is you want the numeric value
of 15 (ensure that it is numeric, and not text) from cell C1.

D1: =SUMPRODUCT(--(A1:A1000=1234),--(B1:B1000=5678),(C1:C1000))
This will check column A, rows 1 through 1000, to see if what is in that
column is equal to 1234 (or whatever cell reference you are using), then do
the same for column B, rows 1 through 1000, to see if it is equal to 5678 (or
whatever cell reference you are using). It will then find the value in column
C, and return that value.
NOTE: If you have multiple matches...
A3: =1234 B3: =5678 C3=15
....
A9: =1234 B3: =5678 C3=25
It will add up the values in column C (this case, 40)
--
John C


"Ali Noor" wrote:

Dear John,

I have applied the formula s below thoug my values were in A1 B1 AND C1 so i
changed it how ever in D column it says 0 rather than 15.

Moreover to look up A1 values in important in B1 as B1 is usualy very long
list and A1 also is long list many a times A1 value might not be in B1
--
Ali.


"John C" wrote:

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.
.

Relevant Pages

  • RE: Vook up help required
    ... "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 ... column is equal to 1234 (or whatever cell reference you are using), ...
    (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)
  • RE: Vook up help required
    ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ... "John C" wrote: ... column is equal to 1234 (or whatever cell reference you are using), ... Facing problem to write a proper lookup formula for following problem, ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Vook up help required
    ... John C ... "Ali Noor" 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
    ... "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)