Home |
Search |
Today's Posts |
#1
|
|||
|
|||
wildcard use in formulas
I am using Excell 2003
I'm trying to set up an "IF" formula in one cell to to assign office location to postcode located in another cell. for example =IF(A1="BD*","Bradford","Leeds" Where the * is a wildcard. The formula doesn't allow this however, as it looks at only what is typed into the A1 cell. For a Bradford return I have had to type BD* in A1. My aim is for an automatic listing of the appropriate office once the post code is typed into the preceding cell. I may be going about this the wrong way. I would be grateful of any help |
#2
|
|||
|
|||
=IF(LEFT(A1,2)="BD","Bradford","Leeds")
-- HTH RP (remove nothere from the email address if mailing direct) "Tobias" wrote in message ... I am using Excell 2003 I'm trying to set up an "IF" formula in one cell to to assign office location to postcode located in another cell. for example =IF(A1="BD*","Bradford","Leeds" Where the * is a wildcard. The formula doesn't allow this however, as it looks at only what is typed into the A1 cell. For a Bradford return I have had to type BD* in A1. My aim is for an automatic listing of the appropriate office once the post code is typed into the preceding cell. I may be going about this the wrong way. I would be grateful of any help |
#3
|
|||
|
|||
I'd use Bob's formula, too, but one way using the wildcard:
=IF(COUNTIF(A1,"BD*")0,"Bradford","Leeds") == But if you have lots of these postal codes, I'd create a table on another sheet. A B BD Bradford LD Leads xx whatever .... =vlookup(left(a1,2),sheet2!a:b,2,false) Tobias wrote: I am using Excell 2003 I'm trying to set up an "IF" formula in one cell to to assign office location to postcode located in another cell. for example =IF(A1="BD*","Bradford","Leeds" Where the * is a wildcard. The formula doesn't allow this however, as it looks at only what is typed into the A1 cell. For a Bradford return I have had to type BD* in A1. My aim is for an automatic listing of the appropriate office once the post code is typed into the preceding cell. I may be going about this the wrong way. I would be grateful of any help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |