Macro for Vlookup

[dshafique]

Hey everyone, I have this report I pull form online which has daily updated dollar values for projects. What I do is, I open my list, and do vlookup using the project code to fill in the dollar values for the projects. However, the issue I have is that there are some projects which share the same project code, so I get duplicate values and it throws off my overall numbers. Is there a way for me to use a macro which only pulls the values for the first instance of the project code? or is there a vlookup/match indx formula which could do that for me as well?

thanks in advance

 

[mrshl9898]

Hi,

It's not entirely clear what is needed here. A VLOOKUP will return the first value, maybe you need to add a sort in there first if you're getting the wrong instance? Some sample data, with your current and expected results would be helpful in finding the solution for you.

As far as a macro goes, sounds like you just need to enter a formula somewhere and drag it down. Try the macro recorder and share your results if you need tweaks made.

 

[offthelip]

This thread shows you a way of doing Vlookup using VBa, it has the advantage that it is faster and much more flexible, ( i.e. you can pick up column to the left). You can change to code to pick up the first value or all values or the second value, last value whatever you want just by making a few changes in the code.
https://www.mrexcel.com/forum/excel-questions/1043185-vlookup-vba-alternative.html

 

[dshafique]

Thanks for your replies. I actually found out I can use SumIF to get what I needed done instead of Vlookup.

thanks
https://www.mrexcel.com/forum/excel-questions/1002657-vlookup-sum-multiple-row-entries.html