Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull value from another sheet
I have multiple sheets in my workbook. On the first sheet, I am pulling data
from all the other sheets for a comparison. I need to pull in a commission level for specific group numbers. Here is what I need: Sheet 1 K3 is where my formula is. I need to match the value from sheet 1 B3 to sheet 2 I4. Then, if they match, I want the value from sheet 2 N4 to show up in sheet 1 K3. Another issue may be that on sheet two there may be multiple group numbers that are the same, however all commission levels for a group number are the same. So I guess I could go average or median if that would help the formula. If someone could help me out, that would be amazing! Let me know if you need any clarification, also. Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Information from one sheet to another | Excel Worksheet Functions | |||
Pull Data from one sheet to another | Excel Worksheet Functions | |||
How do I use a formula on wk sheet 2 to pull data from wk sheet 1 | Excel Discussion (Misc queries) | |||
HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT # | Excel Worksheet Functions | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions |