auto entry from one worksheet to another

L

Laura

I am trying to figure out how to enter text in one cell in worksheet A and
copy the correlating data from worksheet B where ever it is located, not just
a specific cell. Ex. If I enter an item number in worksheet A, I want to pull
the description from worksheet B to automatically be entered in the cell next
to the item number. Any help will be appreciated!
 
S

Sean Timmons

That would be a VLOOKUP.

=VLOOKUP(A2,SheetB!A:B,2,0)

Will search for A2 in column A of SheetB and return the corresponding
information in column B. It will return #N/A if values do not match exactly.

Change the A:B to A:rightmost column and ,2, to the number representation fo
the column across. (i.e. - Table A:D, looking at column A returning value
from column D would require ,4,) if you want to return the closest match,
remove the ,0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Duplicate cell information from one worksheet to another: 1
Get location of match in another worksheet 2
Excel Vba to change displayed year automatically. 14
Linking value of cell on one worksheet to a column on another work 1
Worksheet Names using Macros 5
Formula, Macro, or VBA code to find and insert 3
Reference the same cell based on tab name 1

Top