Forum Discussion
VLOOKUP - COMPLEX FORMULA BASED ON START AND END DATES
Hi everyone, This is very complex! In columns U-X of attached excel, I want the result to show the contract type of the account (column H), but it should also match the contract type it was THAT ...
Hi,
Have you try to make another column with CONCATENATE ? You could have in this new column the contract type & the year of the contract, so that you have a new unique information, that you could match with the same column created in your database?
Baptiste
- Thanks for your reply- I am not sure how that would work. I need each column to reflect the contract type it was THAT year, no matter what the specific start and end dates on the row says.
