I am looking code to insert text into a column based on the value in a specified range, Currently I am using the following vlookup code =VLOOKUP(N3,$AM$2:$AN$8,2,0) but have been finding it very slow when using a macro for the rest of the workbook, I have attached a copy of the workbook showing the code and what I am trying to achieve.
Thanks in advance
Try this formula instead:-
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi Burt,
This works for just the one contact as per your sample:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
xladept, thanks that works great for the one as per the example but is it possible to make it work for all 5 possible contacts in columns N, P, R, T, V.
Thanks and sorry for not being clear.
Johnny
Hi Johnny,
Try this:
Please Login or Register to view this content.
Last edited by xladept; 04-11-2016 at 11:06 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks