hi

In cell A2
=INDEX(Sheet2!A:A,A1,0)

--
Regards
Roger Govier

wrote in message
...
Very new to excel. Here's scenario. On worksheet 1, cell A1 enter 1.
Would like this to cross reference this number within a range of
number on worksheet 2 and report back the data immediately to right
back to cell A2. This down below is how I've entered my data down
below on worksheet 2. Thanks.

1 A 5 E
2 B 6 F
3 C 7 G
4 D 8 H