LookUp Code in VBA

[pezalmendra]

Hi,

Im using the following lookup code in VBA but cannot make it work:

Please Login or Register  to view this content.

The thing is that:

Range("A" & x) is located in Sheet3

Range("A9:A15") is located in Sheet2

Range("F9:F15") is located in Sheet2

Thanks!

Regards,

[zbor]

Try

Please Login or Register  to view this content.

[pezalmendra]

Hi!

It pops up an error also... "Unable to get the Lookup property of the WorksheetFunction class"

[pezalmendra]

Hi again!

I manage to make work it work with the code above but it displays #NA instead the values... strange...

I have attached my workbook if it helps.

Thanks!!

Regards

[mike7952]

Give this a try,

Please Login or Register  to view this content.

[zbor]

I manage to make work it work with the code above but it displays #NA instead the values... strange...

Because your first value is range and not cell.

Please Login or Register  to view this content.

Check mine example above. You need to use first cell Sheets("Trips Overview").Range("AU9") and then loop to others.
see mike's solution.

[mike7952]

Also if your going to use the Lookup you need to convert your values in column A to numbers

Please Login or Register  to view this content.

[pezalmendra]

Yesss!! works great mike!!!
thanks you both for the help and attention!!!

Regardssss!!!

[Cutter]

@ pezalmendra

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.