I am trying to use a formula that will list courses that have booked places less than 10. All the data is in one table and I am just wanting to pull it onto another sheet
I am also trying to do a vlookup with iferror I believe, as I have the vlookup working based on a data validation list I have created but when it places booked is 0 it is usually because the course is finished so would either like it to display course ended for 0 or I would like it to search by future date of course also on table and then only vlookup booked places.
If anyone can I would really appreciate it.
