B
bgkgmg
Sh1 C5:C40 are text values inserted at various times and not in any order.
Sh1 D5
40 are numbers that were inserted next to name and Sh1 E5:E:40 are
additional text values added. In Sh2 C5:C40 are the same text values as Sh1
C5:C40 but in alphabetical order. I am using the SUMIF formula to enter
number values into Sh2 D540. Therefore Sh2 D5 formula is
SUMIF(C5:C40,C2,D540) etc. I want to fill Sh2 E5:E40 with info from Sh1
E5:E40 same as previous col but cannot use sumif because Sh1colE is text.
What formula works?
Thanks
Sh1 D5
40 are numbers that were inserted next to name and Sh1 E5:E:40 areadditional text values added. In Sh2 C5:C40 are the same text values as Sh1
C5:C40 but in alphabetical order. I am using the SUMIF formula to enter
number values into Sh2 D5
40. Therefore Sh2 D5 formula isSUMIF(C5:C40,C2,D5
40) etc. I want to fill Sh2 E5:E40 with info from Sh1E5:E40 same as previous col but cannot use sumif because Sh1colE is text.
What formula works?
Thanks