PDA

View Full Version : Use vlookup formual in data validation



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.