VLOOKUP Formula Help

  • Thread starter Thread starter fiset
  • Start date Start date
F

fiset

I've got two worksheets, "Standards 2004" and "Raw Materials."

I want to pull data from column F on the Standards 2004 worksheet t
populate a column on the Raw Materials worksheet. The Standards 200
worksheet has a product number in column A which will be used as a
identifier in the Raw Materials worksheet.

Example: Standards 2004 shows Product number ABC123 in cell A1 and
cost of $2.00 in F1.

Any place product ABC123 appears in column C of the Raw Material
worksheet, I want $2.00 to populate column F in the same row.

I know this can be done but I'm having real trouble with the formula.
Any ideas
 
In row 1 on the 'Raw Materials' sheet:

=VLOOKUP(C1,'Standards 2004'!A:F,6,0)

HTH
Jason
Atlanta, GA
 
You didn't indicate what else might appear in Column C of the Raw
Materials worksheet; the answers you've received from from Frank Kabel
and Jason Morin assume that nothing else will.

Alan Beban
 
Back
Top