View Single Post
  #5   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

Hi,
Try the following formula in say F2; the assumes that the data are in rows 2
thru 1000, and, D2 and E2 are the search criteria.

=OFFSET(C1,SUMPRODUCT(--(A2:A1000=D2)*--(B2:B1000=E2)*ROW(C2:C1000))-1,0)

Regards,
B. R. Ramachandran


"carlyman" wrote:


I need a way to find a value (could be text) in column C based on the
values in column A and column B. Entries in A and entires in B are not
unique by themselves; however, by "keying" off columns A and B together,
only one entry in column C results.

Example:
A-----B-----C
D-----X-----Test1
D-----Y-----Test2
F-----Y-----Test3

I've tried various index and match combinations, but haven't figured it
out yet. Any ideas?

Thanks,
JC


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=466313