Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    BECCLES, Suffolk, England
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Looking up part of a string (WXpHe O2003)

    I paste into Excel a tax calculation from an accounting programme.
    Approx 3/4's down the pasted -in data is the text string Class 4 National Insurance. If in the accounting programme there is a liability for this item the line underneath the Class 4 National Insurance shows a calculated entry - if there isn't then that line is blank. the line Class 4 National Insurance is a constant, the line underneath it is not. Is there a way of looking up the Class 4 National Insurance and returning the figure from the line below? Many thanks.
    <IMG SRC=http://www.wopr.com/w3tuserpics/StephenElms_sig.jpg> Didn't think that I made my first post here on 5th February 2001...!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Looking up part of a string (WXpHe O2003)

    You could do a "match" on the column of data to get the row number with the "Class 4 National Insurance" and lookup the next row.

    If the value is in column A you could use:
    <pre>=INDEX(A:A,1+MATCH("Class 4 National Insurance",A:A,0))</pre>


    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •