>
> Hi Gaurav,
>
> See this solution, More productive and time saving.
>
> Regards
> Sandeep
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
Hi Gaurav,
See this solution, More productive and time saving.
Regards
Sandeep
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Joi
Hi Gaurav,
While VBA is great (and I use it often), I recommend only using VBA when you
absolutely need to. For starters, many users won't open an XLSM file for
security reasons. Second, there are many more people who can maintain Excel
formulas than there are those who can maintain VBA code. F
Thanks for your help Chris,
The implementation is great.
I would now look to convert this to a VBA function or subroutine.
Thanks again for your help.
Gaurav!!
--
--
Some important links for excel users:
1. Fo
Thanks for the help Shyam,
I have a similar code that would work through this problem but then
this does slow down a bit when i have around 1 line items to
search through. I tried yesterday and using arrays to loop through the
values does fasten the search considerably. I am refining the code
'VLOOKUP PROBLEM WITH MULTI ITEM OR VALUE
'WORK FINE FOR DISTINCT ID/VALUE
Suppose we have client id along with purchase id,such as,if we have multiple
of client id
Then applying vlookup will not give required result.
Client ID
Purchase ID
uw001
cd001
uw002
cd002
uw003
cd003
uw004
c
Hello,
I have tried this for sometime now but maybe i'm missing something.
I'm trying to use VLOOKUP and the range that i'm searching in could
have multiple occurences of the lookup value. I want to get all the
instances of the lookup value. I have tried to use array formulas with
VLOOKUP and MATC