Extension of and IF & VLOOKUP statement
 

Hi,

I written the following formula to extract data from another workbook into
my current work using IF and VLOOKUP.
=IF(B81,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

Presuming your formula:
=IF(B81,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(B81,VLOOKUP(B 8,s3.xls!Sales,8,
0),""),"Settled","")),"Builders Terms",""))

This will remove the phrases: "Settled" or "Builders Terms"
from the original formula's returns
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sal" wrote in message
...
Hi,

I written the following formula to extract data from another workbook into
my current work using IF and VLOOKUP.
=IF(B81,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