Chris has attended:
Excel Advanced course
Vlookup formula
I'm currently using the below formula to look a list of numbers in another list of numbers and if found, output the minutes dialled for that number.
Its looking for the numbers in column G in column A, and if it finds them outputting the minutes dialled which are in column D
=IF(ISERROR(VLOOKUP(G13,$A$2:$D$386,1,FALSE))
,0,VLOOKUP(G13,$A$2:$D$386,4,FALSE))
The problem I have is that for the numbers that are in column G, here are more than one entry in Column A, and the lookup is only finding the first entry.
How can I edit this formula to get it to find all instances of each number in column A and sum all of the related entries in column D?
RE: Vlookup
Hello Chris,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding the use of Vlookup.
Send me your file which contains only the data you are referring to and I will find the best solution to this problem. Unfortunately, Vlookup will always find the first item you are looking for so I will find a workaround which solve this issue.
My email is: rl@stl-training.co.uk
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Vlookup
Hi Rodney,
Thanks for your reply.
I think ive found a solution. If I pivot the data first to get the totals and then run the lookup it should work.
Fingers crossed!
Kind regards,
Chris
RE: Vlookup
Hello Chris,
Did you have any joy with your proposed solution?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
