LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Validate field

How I do to validate one field with condicional function? I am doing it.
Made one matrix call Brand and others call Model_A, Model_B, Model_C...
I

n Brand I put, for example, ADC, Belden, Sony, Toshiba ...

In the others, for example Model_ADC, I put the all models reference the ADC
Brand, and I repeat this operation for next matrix.

Now I create one cell with validade Brand with suspense list. It is OK.
(data-validade-list-font (=Brand).

After I create one cell with condicional validade. It is Ok.
(data-validade-list-font
=SE(E15="ADC";Model_ADC;SE(E15="Belden";Model_Beld en;FALSO)).

The problems is that the field font accept just only 255 word and my data is
bigger.

Someone knows what to do it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking up a name and then being able to validate it twynsys Excel Worksheet Functions 0 November 29th 06 02:48 PM
Looking up a name and then being able to validate it twynsys via OfficeKB.com Excel Worksheet Functions 0 November 21st 06 04:43 PM
Search and Validate Mike Smith NC Excel Discussion (Misc queries) 2 July 10th 06 04:14 AM
Validate a result nobbyknownowt Excel Discussion (Misc queries) 3 July 5th 06 03:59 PM
How to validate edwardpestian Excel Worksheet Functions 4 June 9th 06 01:13 AM


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"