input # on sheet 1, pulls all info for # from sheet 2

M

moochx5

I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items
listed down, all items have a unique number. When I enter that number in
sheet one how do I get it to pull all the info from sheet 2 onto sheet 1?
 
R

roundabout

Use VLOOKUP. It's really simple to set up and once you've got the hang
of it you'll wonder how you ever managed to live without it.

Until you find INDEX/MATCH of course! ;-)


Anyway, send me your book and I'll show you if you like

Lee
 

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

Copy Data from One sheet to Different Sheets 1
Using lookup functions for Order Sheet 1
Imbedded Data Input sheet 3
how to increment sheets in an excel formula with auto fill 1
Macro to Compile Data from Different Sheets 2
comparing sheet to sheet and adding value 1
Integrating information from Word to Excel (not mail merge) 1
How to list cells from two sheets that has different values in theirneighboring column? 8

Top