Extension of and IF & VLOOKUP statement

[Sal]

Hi,

I written the following formula to extract data from another workbook into
my current work using IF and VLOOKUP.
=IF(B8>1,VLOOKUP(B8,S3.XLS!Sales,8, 0),"")

I would also like to be able to to only extract some of this information;
These are examples of the data:
Settled 4.8.04
Builders Terms B4 5.7.05

BUT I would only like to see B4 5.7.05 and not include words like Settled
and Builders Terms.

Any ideas?

Thanks

 

[Max]

Presuming your formula:

=IF(B8>1,VLOOKUP(B8,S3.XLS!Sales,8, 0),"")

is in C8 and is returning values such as:

Settled 4.8.04
Builders Terms B4 5.7.05

then you could try instead in C8:
=TRIM(SUBSTITUTE(TRIM(SUBSTITUTE(IF(B8>1,VLOOKUP(B8,s3.xls!Sales,8,
0),""),"Settled","")),"Builders Terms",""))

This will remove the phrases: "Settled" or "Builders Terms"
from the original formula's returns