Using Lookup or Match?

[Jack]

I have to match a part number column in one worksheet, say
column 'B" with a price list in another worksheet in
column 'k'. What would be the best way to combine the two?

 

[Frank Kabel]

Hi
maybe something like
=VLOOKUP(B1,'other_sheet'!$K$1:$L$100,2,0)

See: http://www.mvps.org/dmcritchie/excel/vlookup.htm