| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move text
Sh1 C5:C40 are text values inserted at various times and not in any order.
Sh1 D5:D40 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 D5:D40. Therefore Sh2 D5 formula is SUMIF(C5:C40,C2,D5:D40) 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Move text
Try this in E5:
=VLOOKUP(C5,Sh1!C$5:E$40,3,0) and copy down to E40. Hope this helps. Pete On May 10, 11:34*pm, bgkgmg wrote: Sh1 C5:C40 are text values inserted at various times and not in any order. * Sh1 D5:D40 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 D5:D40. *Therefore Sh2 D5 formula is SUMIF(C5:C40,C2,D5:D40) 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 * |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find text and move it | Excel Discussion (Misc queries) | |||
| Trying to move text but not cells | Excel Worksheet Functions | |||
| move a text box to the back | Excel Discussion (Misc queries) | |||
| Line and text box move by themselves | Charts and Charting in Excel | |||
| How to move text from Row to Column | Excel Discussion (Misc queries) | |||
Linear Mode
