Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Syntax Error | New Users to Excel | |||
Statement | Excel Worksheet Functions | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
IF or Vlookup or.... Which is best for this example: | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |