Hi ramdubai
Are the criteria values unique! If they are, try the following. assuming your data is in A1:C100 including column headers.
=LOOKUP(2,1/((A2:A1000=Value1)*(B2:B1000=Value2)),C2:C1000)
If there are multiple criteria which match, then try the array formula ("ctrl + shift + enter" to commit)
=IFERROR(INDEX($C$2:$C$1000,SMALL(IF(($A$2:$A$1000=Value1)*($B$2:$B$1000=Value2),ROW($2:$1000)-ROW($1:$1)),ROW($A1))),"")
Kevin
Perhaps something along these lines.
=IF(A1=B1,C1,"")
if i have a column a and in column we have two or more same no.(like ab-230,ab-230),randomaly. i want to search them and add there value.
ex:
A B C
ab-230 2 4
an-25 4 7
ab-230 3 6
we want to add column a like
A b C
ab-230 5 10
pls reply me
I have two an excel with 3 sheets. One sheet has desc column, another sheet has id column and desc column. now I have to compare two descs and fetch the id value in another column.
example
zone1 zone2 id
hyd blr 1 3
hyd hyd 2 1
blr che 3 4
che tec 4 0
if zone1 value wherever occur in the zone2, then corresponding id value has to display in D column .
Please advise.
Regards
Prabhakar