Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula in excel 2003
Is it possible to have a formula that says: "IF A3 "begind with 'P' return a
value of 'ELECTRICAL' in cell G3" or is this type of formula to complex for Excel to handle? I am attempting to have certain cells fill in automatically based on imported data. Thanks, Samantha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula in excel 2003
Hi Samantha
=IF(LEFT(A3)="P","ELECTRICAL","Value otherwise") will do this. But I presume you will have a range of values you want returned dependent on what the cell contains? In which case I suggest you look at VLOOKUP - a possible form would be: =VLOOKUP(LEFT(A3),LookupSheet!$A$1:$B$10,2,0) where you have a table in LookupSheet in A1:B10 with the single letters you want to lookup in the A column (eg "P" etc) and the value to return in the corresponding B column eg "Electrical" Richard "samantha" wrote in message ... Is it possible to have a formula that says: "IF A3 "begind with 'P' return a value of 'ELECTRICAL' in cell G3" or is this type of formula to complex for Excel to handle? I am attempting to have certain cells fill in automatically based on imported data. Thanks, Samantha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 formula | Excel Worksheet Functions | |||
need help with a formula in excel 2003 | Excel Worksheet Functions | |||
Help with Formula (Excel 2003) | Excel Discussion (Misc queries) | |||
Can I get help with an excel 2003 formula | Excel Worksheet Functions | |||
Excel 2003 - Need Formula Help | Excel Discussion (Misc queries) |