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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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