| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Second cell in Data Validation
Can Data Validation return a value to a second cell from an adjacent column
in the list as well as the first cell when validation criteria is set as list? -- Bill |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Second cell in Data Validation
Bill,
Use a formula like =IF(A2<"",VLOOKUP(A2,$D$2:$E$100,2,False),"") where A2 has data validation based on the first column of your list in $D$2:$E$100. HTH, Bernie MS Excel MVP "WFariss" wrote in message ... Can Data Validation return a value to a second cell from an adjacent column in the list as well as the first cell when validation criteria is set as list? -- Bill |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Second cell in Data Validation
Are you suggesting that I put that formula in the second cell?
-- Bill "Bernie Deitrick" wrote: Bill, Use a formula like =IF(A2<"",VLOOKUP(A2,$D$2:$E$100,2,False),"") where A2 has data validation based on the first column of your list in $D$2:$E$100. HTH, Bernie MS Excel MVP "WFariss" wrote in message ... Can Data Validation return a value to a second cell from an adjacent column in the list as well as the first cell when validation criteria is set as list? -- Bill . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Second cell in Data Validation
Yes.
Any cell but A2 or within the table range of D2:E100 Try entering Bernie's formula in B2 Gord Dibben MS Excel MVP On Wed, 17 Feb 2010 14:57:02 -0800, WFariss wrote: Are you suggesting that I put that formula in the second cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| how blank data validation cell after changing dependent cell? | Excel Discussion (Misc queries) | |||
| Data Validation-Only allow entry into cell if adjacent cell is fil | Excel Discussion (Misc queries) | |||
| Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
| Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) | |||
Linear Mode
