Then I would run a column based formula in my Sales Query which lookedup the related Sales Person based on the combination of the customer and month?Īny thoughts would be awesome or even a link to another page which might solve this. Step-by-Step Procedures to Use VLOOKUP & HLOOKUP Combined Formula Together in Excel How to Use IF Statement with VLOOKUP Function 1. I am wondering if there is a measure (or some other method) that could be created to achieve this.Īnother option could potentially be where I link it to a 'date effective' column like the below table Press Enter to apply the formula in cell E2. Assign the formula IF(VLOOKUP(D2,A2:B6,2,FALSE)>2500,Yes,No) to cell E2. How do you combine VLOOKUP and function together Combine IF Function with VLOOKUP Select cell E2 by clicking on it. In excel I use the Index/Match to pull a column reference (basically the equiv of an HLOOKUP). For short, this is referred to as just the Index Match function. In the example below the Customers B + C are moved in June to Salesperson 2 - so I want a way to allocate sales based on the month. I havent come across a potential solution so keen for thoughts
0 Comments
Leave a Reply. |