Vlookup & Trim
 

I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
spreadsheet.

Here's what it looks like.

Spreadsheet one, Column B: 12345678_987654321

I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.

Spreadsheet one, Column D has number 987654321. I need to use this as an
anchor to put the right numbers from spreadsheet one, column B into
spreadsheet two, column D.

THANK YOU!!!

Vlookup & Trim
 

If I have understood correctly...

in sheet2 D2 use this formula copied down column

=LEFT(INDEX(Sheet1!B:B,MATCH("*"&Sheet1!D2,Sheet1! B:B,0)),8)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508284

Vlookup & Trim
 

are you familiar with vlookup?,=left(vlookup(customer
id,sheet1!table_array,2,false),8)
--
paul
remove nospam for email addy!



"Paperback Writer" wrote:

That won't anchor me, will it?

Let me explain better.


Sheet 1.

Column B Column C
NUM NAME
987654321 12345678 987654321


Sheet 2.

Column E Column D
ID SEC NUM
987654321 (I need this to say) 12345678

From S2, column E can hook into S1, column B. I need the first 8 characters
of S1, column C to go into S2, column D.



"paul" wrote:

say in d2 of sheet2 =LEFT(sheet1!B2,8)

--
paul
remove nospam for email addy!


"Paperback Writer" wrote:

I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
spreadsheet.

Here's what it looks like.

Spreadsheet one, Column B: 12345678_987654321

I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.

Spreadsheet one, Column D has number 987654321. I need to use this as an
anchor to put the right numbers from spreadsheet one, column B into
spreadsheet two, column D.

THANK YOU!!!

Vlookup & Trim
 

That won't anchor me, will it?

Let me explain better.


Sheet 1.

Column B Column C
NUM NAME
987654321 12345678 987654321


Sheet 2.

Column E Column D
ID SEC NUM
987654321 (I need this to say) 12345678

From S2, column E can hook into S1, column B. I need the first 8 characters
of S1, column C to go into S2, column D.



"paul" wrote:

say in d2 of sheet2 =LEFT(sheet1!B2,8)

--
paul
remove nospam for email addy!


"Paperback Writer" wrote:

I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
spreadsheet.

Here's what it looks like.

Spreadsheet one, Column B: 12345678_987654321

I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.

Spreadsheet one, Column D has number 987654321. I need to use this as an
anchor to put the right numbers from spreadsheet one, column B into
spreadsheet two, column D.

THANK YOU!!!

Vlookup & Trim
 

say in d2 of sheet2 =LEFT(sheet1!B2,8)

--
paul
remove nospam for email addy!


"Paperback Writer" wrote:

I have this dilemma. I have a number in column B of spreadsheet one. I need
to split that number and put the first 8 digits into column D of another
spreadsheet.

Here's what it looks like.

Spreadsheet one, Column B: 12345678_987654321

I need to put into spreadsheet two, Column D: 12345678 from spreadsheet one.

Spreadsheet one, Column D has number 987654321. I need to use this as an
anchor to put the right numbers from spreadsheet one, column B into
spreadsheet two, column D.

THANK YOU!!!