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

Have a look in the help index for VLOOKUP
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

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