Linking Multiple Excel Sheets

  • Thread starter Thread starter foolio
  • Start date Start date
F

foolio

Okay here's what im trying to do...

I have two diff documents...

doc 1) contains a list of about 1000 part numbers

doc 2) contains about 50000 part numbers and descriptions

I need to pull the descriptions out of doc 2 wherever the part number
match each other....

Now I have done this exact same thing with prices instead o
desc....but the problem is when i do the prices i use sumif and sinc
the desc arent numbers it doesnt work....


any help would be MUCH appreciated, thx -jon aka fooli
 
hi
if your part numbers are in column a and you want the entry from column
b of sheet 2 use VLOOKUP. e.g. enter in B1 on sheet 1 the following
formula
=VLOOKUP(A1,'sheet2'!$A$1:$B$50000,2,0)
and copy down
Note: This may cause a lot of calculation time. You may uncheck
automatic calculation in the options dialog
 
Back
Top