Posted to microsoft.public.excel.worksheet.functions
|
|
Sumproduct - number & text
See http://www.contextures.com/xlFunctio...ml#IndexMatch4 for a solution
"Kashyap" wrote:
I just want to lookup 2 columns and get the result from the 3rd column. But
here 2 columns are text and number in one column.
|