I have a problem regarding data validation. please see the attached excel file and tell me for the problem and for the possible solution. If possible not to have macros in the solution because I am not really good in macros.
thank you
I have a problem regarding data validation. please see the attached excel file and tell me for the problem and for the possible solution. If possible not to have macros in the solution because I am not really good in macros.
thank you
Welcome to the forum.
Next time please ask the question in the thread and not the workbook
Try this formula
VBA Noob=IF(ISNA(VLOOKUP(C12,C4:D6,2,FALSE)),"",VLOOKUP(C12,C4:D6,2,FALSE))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
VBA noob,
first of all thank you for the advice and for the solution. Its amazing!
I have a follow up question if you dont mind.
Is it possible to use your solution even if is copy and paste it to other cell?
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks