Using Vlookup

[Potholes]

Good Evening all

I have attached the file that I am working on, it has worksheets named, " Master, VK1, VK2,VK3,VK4,VK5,VK6,VK7,VK8,VK9,VK0 "

On the master sheet I have areas the do a search for data in each of the cells related to the call sign that I enter in cell " C1",

There seems to be a problem where we have cells with multiple of the same call sign,

Please Login or Register  to view this content.

I have further ideas to resolve when this is solved. ONE STEP AT A TIME.....

Peter

[AliGW]

You missed the final argument:

=VLOOKUP($C$1,'VK4'!$A$2:$Q$200,2,0)

Please try to make your thread titles more descriptive - this one is borderline. Think Google search when composing your title.

[Potholes]

Thank you AligW

I amended the formular and it works now,

Do you want me to mark as Solved.

Peter

[AliGW]

Yes, please.