| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
