What formula would I use?

[Jack]

I need to match a part number in column B with a list of
part numbers (column T) with prices (column Y) to return
the price to column C.

 

[Frank Kabel]

Hi Jack
try in C1
=VLOOKUP(B1,$T$1:$Y$100,6,0)

 

[Claudia]

Hi Frank,

I need to match in source document the column 2 & 3 from
several workbooks usin column 1 as match. What formula
can I use

 

[Frank Kabel]

Hiclaudia
not quite sure what your spreadsheet looks like exactly?. Can you give
an example? (plain text - no attachment please)