Hi guys, (apologies for the title.. not sure what happened there.. was ok until I clicked save)

I have a table of data which is three columns wide and hundreds and hundreds of rows in length.

What I need is a user form that if I type a Number in say Textbox1..

It finds that number in column A then returns Column B in textbox2 and Column C in Textbox 3.

How do I code this in VBA?