Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |