• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

How to return a result from another tab in Excel

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.
0
timamartin
Asked:
timamartin
1 Solution
 
NBVCCommented:
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
0
 
duncanb7Commented:
IN sheet2, Excel cell type on A1 cell , for example,
=sheet1!A1 that will call A1 cell value from sheet1 and put it
on sheet2 cell A1

and do anything you want  , for example, =sheet1!A1*100/5, and click % on meun bar

Hope understand your question completely.If not, please point it out
Duncan
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now