Hi,

I had a table of data and would like to go the following... please help...
A B C D
1 Andy 78 98 85
2 Jane 45 65 96
3 David 12 32 41
4 Sam 23 74 52

If I type in "Andy" in Cell 1, I like Cell 2 to display 78, Cell 3 to
display 98 and Cell 4 to display 85 automatically.

Please help. Thank you.