VBA Vlookup

[igormigor]

Hi all,

I have problem with probably quite simple solution.

When I run the macro, a input box will appear in which number from 1 to 36 need to be entered.
With vlookup, I like to find the value with have the order number which was entered in the input box.
This value will be taken in the range "Numbers_and_letters" in sheet "Pickup_list".
After that, I like the value to be entered in cell B2 in sheet "Test", and message box to appear that the value was entered.

The only problem in the code is the lookup function.

Can anyone help me with it.

Thank you

Please Login or Register  to view this content.

[nilem]

Hi Igormigor,
maybe so

Please Login or Register  to view this content.

[igormigor]

Hi Nilem,
Thanks for the fast reply. it works.
I was so much trying to fix the vlookup did not even thought to use index :s
Cheers.
Igor