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

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

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.

Trim and copy
 

I was not specifying the correct column. It works as expected. Thanks for
your help!

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!