VLOOKUP IF CALCULATION

Hello Adrian,

Thank you for your question. I notice that you have attended VBA training with us. If you need to use VBA to do this task, please write to us again.

If you simply want to do this in Excel, I would recommend using Index and Match to get the results you want, simply because it seems that the columns from which you want to extract the results are to the left of your Deal Reference columns. Vlookup wouldn'be able to look at columns to the left of the Deal Reference columns. Index and Match can do this.

I have prepared and attached a simple workbook with two sheets vaguely similar to your data. On Sheet 1, there are Index and Match formulas down column C which look at the data on Sheet 2. They indicate the Deal References where it says "Sell". You will notice that I have mixed up the references on Sheet 2, so it doesn't matter if they aren't in the same order.

I hope this helps. If not, please feel free to ask again.

Kind regards
Marius Barnard
Excel Trainer