How to get cell input to access list?
 

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

How to get cell input to access list?
 

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

How to get cell input to access list?
 

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