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!!!