Formula Needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two spreadsheets. Each has in common a unique identifier which is an 8
digit number used in both spreadheets. In one of the spreadheets there is a
product description that can run to as many as 70 text characters. What I
need is a sort of partial vlookup I think. Example: sheet 1 has a unique
identifier of 40002796. I need a formula that will go to sheet 2 and bring
over the first 25 text character (for my purposes thats as many as I work
with) associated with 40002796.

Is this doable?
 
=LEFT(VLOOKUP(A2,Sheet2!A:B,2,False),25)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Assuming what you're looking up is in A1 and your lookup range is A1:B10 on
sheet2

B1: =LEFT(VLOOKUP(A1,Sheet2!A1:B10,2,FALSE),25)

The formula looks for an exact match in A1:A10 on sheet2 and returns the
first 25 characters of the corresponding cell in B1:B10
 
It works, thanks to both you and Bob
--
Clark


Tyro said:
Assuming what you're looking up is in A1 and your lookup range is A1:B10 on
sheet2

B1: =LEFT(VLOOKUP(A1,Sheet2!A1:B10,2,FALSE),25)

The formula looks for an exact match in A1:A10 on sheet2 and returns the
first 25 characters of the corresponding cell in B1:B10
Click to expand...
 
Back
Top