Hi Lolly,
It is so easy to rearrange columns. What is good for data entry is
usually in the order you want to look at them. Rearranging columns.
http://www.mvps.org/dmcritchie/excel...nd.htm#movecol

However for what you asked...
You can affect how the cursor moves by the Enter key (direction),
Tab key, arrow keys, and prevent entry into cell with cell protection in effect.

An event macro to
go to B in next row after entry in C
go to A in same column after entry in B
go to C after entry in A

I don't know if this will help you or frustrate you but the Event macro
will only move the cursor after entry. If you make a mistake the undo
key will return you the last change and it's previous value...

More information on Event macros in
http://www.mvps.org/dmcritchie/excel/event.htm

Install the following by right click on the sheet tab, then view code.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Column
Case 3 'After Entry in C next row column B
Target.Offset(1, -1).Activate
Beep '-- may be distracting but intent is to indicate new row
Case 2 'After Entry in B same row column A
Target.Offset(0, -1).Activate
Case 1 'After Entry in A same row Column C
Target.Offset(0, 2).Activate
End Select
End Sub

If you make a mistake use the Undo key Ctrl+Z to return from your last change was made.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lolly" wrote in message ...
Using Excel 2000 and with three columns, A, B and C for example, after
entering a number in column B, is it possible to jump back to column A in
which there is a vlookup equation, and then jump forward two columns to
column C?

Your solution would be gratefully received.