B
bgkgmg
Sh1 C5:C40 are text values inserted at various times and not in any order.
Sh1 D540 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 D540 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