How to get cell input to access list?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hacdunqh@hotmail.com - 19 Feb 2008 18:36 GMT

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

Reply to this Message

Don Guillett - 19 Feb 2008 19:15 GMT

Have a look in the help index for VLOOKUP

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 6 lines]
> 3 C 7 G
> 4 D 8 H

Reply to this Message

Roger Govier - 20 Feb 2008 00:42 GMT

hi

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

Signature

Regards
Roger Govier

> 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
[quoted text clipped - 6 lines]
> 3 C 7 G
> 4 D 8 H

Reply to this Message