-
Use vlookup formual in data validation
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,FALS E))
thanks,
Rajesh.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules