Vlookup with dynamic range selection using Inputbox

Can anyone help me to perform Vlookup functionality by accepting the range using inputbox. For example, i have 2 columns column A and Column B as mentioned below:

Column A Column B

1 4
2 5
3 1
4 3
5 10
6 9

I want to select the range via inputbox and vlookup the values in Column B with values in Column A or vice versa and find out the difference. Or is there any better way to achieve the same? The following is a simple macro generated with Range hardcoded.

Please Login or Register  to view this content.

Can someone help me with the above requirement?

Hi Pavan Renjal,
Look at the last post in this thread. Maybe you'll find something suitable for you

Hi Nilem,

Can you help me explain this? I am relatively new to macro here. I did a walkthrough but i didnt find anything for me there, i want to use Vlookup functionality.

Bulls Eye! Thanks for all your time and effort Sixth Sense!!