Thread: *-- VLOOKUP --*
View Single Post
  #1   Report Post  
KL
 
Posts: n/a
Default

if the colum A and B combinations are unique, you could also use:

=SUMPRODUCT(C1:C10*(M4&N4=A1:A10&B1:B10))

Regards,
KL

"cmart02" wrote in message
...
Hi,

YOu can do this:

=INDEX(ColumnC,MATCH(M1&N1,ColumnA&ColumnB,0),1)

Now, press CTRL+SHIFT+ENTER and it is done.

I am recruting new members for my forum below... The site went live this
weekend and if you wish to take part, please, join me there so that we can
exchange some ideas. :-D

--
Regards
Robert
Find me at www.msofficegurus.com - be part of it!