Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and copy
I have multiple worksheets.
Sheet1 contains: System Group Level Status Description SYS1 SF99530 0007198 4 CUMULATIVE PTF PACKAGE C7198530 SYS2 SF99530 0007016 4 CUMULATIVE PTF PACKAGE C7016530 Sheet2 contains: System Current CUM SYS1 SYS2 How can I have sheet 2 automatically update based on referencing and trimming cells in sheet1 to result in: System Current CUM SYS1 C7198530 SYS2 C7016530 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and copy
Your example is a bit short on detail, but try this:
=RIGHT(VLOOKUP(A2,Sheet1!A$2:E$20,5,0),8) and then copy down as required. If SYS1 occurs many times in your data (assumed to be 20 rows in the formula), then this will return the first occurence, so you will need another field to help make it unique. Hope this helps. Pete On Nov 21, 6:15 pm, bmolintas wrote: I have multiple worksheets. Sheet1 contains: System Group Level Status Description SYS1 SF99530 0007198 4 CUMULATIVE PTF PACKAGE C7198530 SYS2 SF99530 0007016 4 CUMULATIVE PTF PACKAGE C7016530 Sheet2 contains: System Current CUM SYS1 SYS2 How can I have sheet 2 automatically update based on referencing and trimming cells in sheet1 to result in: System Current CUM SYS1 C7198530 SYS2 C7016530 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and copy
I'm receiving error "a value is not available to the formula of function".
More info - Sheet1 data is a result of an MS query from an IBM iSeries system. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and copy
I was not specifying the correct column. It works as expected. Thanks for
your help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and copy
You're welcome - thanks for feeding back.
Pete On Nov 21, 9:53 pm, bmolintas wrote: I was not specifying the correct column. It works as expected. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using =TRIM() | Excel Worksheet Functions | |||
Trim | Excel Worksheet Functions | |||
Trim if? | Excel Worksheet Functions | |||
trim | Excel Worksheet Functions | |||
Trim Again | New Users to Excel |