I have a workbook with 2 worksheets. Sheet 1 has a table ranging from A1 to
M200. Sheet 2 has a table with matching data from Sheet 1s table A, F & I
columns placed in Sheet 2s A, B & C columns. I need to match the data in
Sheet 1s table A & F columns and Sheet 2s A & B columns to get the data
from Sheet 2s C column. The data from Sheet 2s C column will be placed in
Sheet 1s I column.
Example: Sheet1 A1 Part#
Sheet1 F1 Vendor
Sheet1 I1 Shelf Life

Sheet2 A1 Part#
Sheet2 B1 Vendor
Sheet2 C1 Shelf Life

The reason I need to match Part# and Vendor is that different vendors for
the same Part# may have different shelf lives

The question is can I look up 2 different variables of an item and get a
single result?