Posted to microsoft.public.excel.worksheet.functions

Scott R

external usenet poster

Posts: 54

Data Validation Custom with V Lookup

Hi Everyone, I am a bit confused here.. trying to have a cell validated to
only allow between 2 numbers (depending on the vlookup).. i have tried a
formula below which wont work.. not sure if i can even do such a validation?
any help on this would be greatly appreciated..

=IF(J41="hannan",'=(VLOOKUP(C41,'Insert
Label'!W3:Y8,2,0))'<=(vlookup(c41,'insert label'!w3:y8,3,0))," ")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
custom data validation	Gareth[_2_]	Excel Worksheet Functions	3	May 22nd 08 02:26 PM
custom data validation	Gareth[_2_]	Excel Worksheet Functions	4	May 21st 08 06:48 PM
Custom Data Validation	Steve E	Excel Discussion (Misc queries)	1	September 2nd 06 10:16 PM
Custom data validation	Guy Normandeau	Excel Discussion (Misc queries)	3	April 18th 06 04:12 PM
Data Validation - Custom	Mary Ann	Excel Discussion (Misc queries)	4	December 17th 05 09:22 PM

All times are GMT +1. The time now is 07:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us