| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT formula help
Glad we could help Serge.
Regards Bob "Serge" wrote in message ... I have learned a lot. Thank so much Bob and to everyone else that had an input in my request. "Bob Phillips" wrote: Yes, use =IF(ISNA(VLOOKUP(I40, INDIRECT(VLOOKUP(D40, $R$1:$S$9,2)),2,TRUE)),"",VLOOKUP(I40, INDIRECT(VLOOKUP(D40, $R$1:$S$9,2)),2,TRUE) -- HTH Bob Phillips (remove nothere from email address if mailing direct) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| do I need array formula or sumproduct for counting? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Modify A SumProduct Formula | Excel Worksheet Functions | |||
| sumproduct formula to slow | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
