| View previous topic :: View next topic |
| Author |
Message |
orangehenry
Newbie
Joined: 13 Sep 2011
Posts: 4
Location: Australia
|
 Posted: Wed Oct 05, 2011 8:38 pm Post subject: Conditional Text with multiple terms |
 |
|
Hi,
I know there are alot of entries regarding conditional text on this forum but I'm quite new to this so I'm finding alot of the material over my head.
What I wish to do is have is have a field where the text presented is dependent on the contents of a cell in a spreadsheet.
i.e. If Sheet1. A1 = x then "blah blah"
If Sheet1.A2 = z then "ho hum"
Is I worked out how to use the then:else function but this only gives me one option per field. Is there a way to have many (say 10+)?
Thanks for the help! |
|
| Back to top |
|
 |
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
Location: Hoorn NH, The Netherlands
|
| Posted: Thu Oct 06, 2011 7:22 am Post subject: |
|
|
Take a look at the VLOOKUP function
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
orangehenry
Newbie
Joined: 13 Sep 2011
Posts: 4
Location: Australia
|
| Posted: Tue Oct 11, 2011 9:04 pm Post subject: |
|
|
| DiGro wrote: | | Take a look at the VLOOKUP function |
I've had a look at VLOOKUP, I can work out how to make it lookup the contents of a cell but not how to return text based on those contents. |
|
| Back to top |
|
|
|
