Dear Excel experts,
I'm experiencing some problems combining vlookp function with a IF statements. In fact the xls contains 2 worksheets:, 1 with an overview of different contractors/prices/.. for each part of a construction project and 1 worksheet with the retained/selected contractors based on their offers. In the 2nd worksheet I've taken over the different types of skills (sheet 2, column 1) and with value I need to lookup in the 1st sheet the corresponding skill. As I've requested different offers at different contractors for a specific type of work (skill), I need to filter out the one that I've selected. If this value is true, then the price of this one should appear in the 2nd worksheet. I've been searching for hours now for the flaw in the formula, but can't find it. Can anyone help me out please? Thank you very much for that.
The source file can be found here: https://onedrive.live.com/redir?resid=AC08151E97DC0D03!1001
kr,
Marc
I'm experiencing some problems combining vlookp function with a IF statements. In fact the xls contains 2 worksheets:, 1 with an overview of different contractors/prices/.. for each part of a construction project and 1 worksheet with the retained/selected contractors based on their offers. In the 2nd worksheet I've taken over the different types of skills (sheet 2, column 1) and with value I need to lookup in the 1st sheet the corresponding skill. As I've requested different offers at different contractors for a specific type of work (skill), I need to filter out the one that I've selected. If this value is true, then the price of this one should appear in the 2nd worksheet. I've been searching for hours now for the flaw in the formula, but can't find it. Can anyone help me out please? Thank you very much for that.
The source file can be found here: https://onedrive.live.com/redir?resid=AC08151E97DC0D03!1001
kr,
Marc
