RE: Vlookup where value begins with

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
What about somthing like:

If A2 starts with X2 then VLOOKUP(...) else A2
= IF( LEFT(A2,LEN(X2)) = LEFT(X2,LEN(X2)) , VLOOKUP(...) , A2 )

--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Stephen" wrote:

I have a nother vlookup problem where I'm hoping to be able to return a value
if the lookup value BEGINS with a certain number which can be found in a
particular cell... I'm not sure it's going to be possible to say...

If the lookup values in the named range begin with the value found in cell
x2, then return the value from the third column in the namged range.

thanks in advance.
.

Relevant Pages

  • Re: VLOOPUP
    ... You need to make sure the cell format is the ... This info is looked up on the Product List which is a different worksheet ... 1st arguement => value to lookup. ... Named Range, etc. going across to the right. ...
    (microsoft.public.excel)
  • Re: VLOOPUP
    ... First make your Named Range as ... Then click in cell where you what the result to appear. ... 1st arguement => value to lookup. ... range on the other worksheet. ...
    (microsoft.public.excel)
  • Re: Vlookup problem
    ... In the adjacent cell, look to see if it returned an error. ... "Dave Peterson" wrote: ... I set the lookup formula in enquiry.xls to lookup the tel nos. ... The enquiry.xls is with the vlookup formula to lookup the data in data.xls. ...
    (microsoft.public.excel.misc)
  • Re: Validate Entry Custome Formula and Data Names
    ... Microsoft Excel MVP ... Using the specific range instead of a named range is no big deal however, ... If I do the test in a cell, ... but it doesn't in the Validation formula of Q2. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: combining LOOKUP and IF functions
    ... You need to use Match and get a cumulative sum of you percentages. ... cell I2 =A2+H2 ... It may be possible to use Lookup ... excel spreadsheet and then plot the result of the model. ...
    (microsoft.public.excel.worksheet.functions)