Forum

hi Melanie Shortcut for creating dropdown box is Alt DL and any cell in excel can the length of any cell in excel can be automated by Alt HOI Pe...

Hi Frans thank you ,got it ,check below formula for the calculation =SUMPRODUCT(INDEX(C5:N17,MATCH("Jackie",B5:B17,0),),C20:N20)

HI see attached xls file Regards

the HLOOKUP Can automatically be updalted by using match formula on the row_index_number part on the hlookup formula.Kindly attach the file and can as...