Hello
Could you tell me how to add the following formula into my Macro on cell D2:
=IF(ISERROR(VLOOKUP(A2,AF!$A$1:$B$71,2,FALSE)),"Not included in list",VLOOKUP(A2,AF!$A$1:$B$71,2,FALSE))
Thank you
Hello
Could you tell me how to add the following formula into my Macro on cell D2:
=IF(ISERROR(VLOOKUP(A2,AF!$A$1:$B$71,2,FALSE)),"Not included in list",VLOOKUP(A2,AF!$A$1:$B$71,2,FALSE))
Thank you
Hello smile7982,
Welcome to the Forum!
Please provide either a workbook or a more detailed example of what you to do. Case in point, what is in cell D2? How about the macro code?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Maybe:
Please Login or Register to view this content.
Thank you John it worked!
You're welcome. Glad to hear that, and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks