rajesh nag
09-30-2008, 11:55 PM
Hi,
I am using a formula if the value is selected from a list in a cell to get the corresponding value of that value in that list. if i use this formula directly in cell h15, i am getting the result perfectly but if i use the same formula in data validation custom un able to get the result.
I cann't use this formula to the cell since i have set some validation to the sheet. can any one help me on this.
here is the formula
=IF(iserror(VLOOKUP(G15,code_name,2,FALSE)),"",VLOOKUP(G15,code_name,2,FALSE))
thanks,
Rajesh.
I am using a formula if the value is selected from a list in a cell to get the corresponding value of that value in that list. if i use this formula directly in cell h15, i am getting the result perfectly but if i use the same formula in data validation custom un able to get the result.
I cann't use this formula to the cell since i have set some validation to the sheet. can any one help me on this.
here is the formula
=IF(iserror(VLOOKUP(G15,code_name,2,FALSE)),"",VLOOKUP(G15,code_name,2,FALSE))
thanks,
Rajesh.