Results 1 to 2 of 2
2005-01-04, 20:57 #1
- Join Date
- Feb 2001
- BECCLES, Suffolk, England
- 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...!
2005-01-04, 21:03 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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>