How to get cell input to access list?

  • Thread starter Thread starter hacdunqh
  • Start date Start date
H

hacdunqh

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
 
Back
Top