新聞財經娛樂♬資訊 News Economy

I have an Excel spreadsheet with two tabs. Sheet 1 has part information for this month such as part number, description, price, etc. Sheet 2 has a complete list of part numbers in column A and commission percentages in column B.

When I enter a part number in sheet 1 I want it to automatically fill in the percentage based on the source info in sheet two. So I will provide part numbers in sheet one each month and the commission percentage will be filled in automatically based on the info in sheet 2.

You can do it with VLOOKUP.

e.g.

=VLOOKUP(A2,'Sheet2'!A:B,2,FALSE)

if there is a possibility of no match and you want to return a blank (or other comment), then use IFERROR()

e.g

=IFERROR(VLOOKUP(A2,'Sheet2'!A:B,2,FALSE),"")

copied down