theonlyhamish
New Member
- Joined
- Aug 13, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi folks, first time be gentle lol. Ive had a look at similar questions but im still not managing to get this one.
Im trying to populate column J (this year) based on the specific values in columns B (type), E (date last visit), G (score) and H (urgent) in the same row.
so in my simplistic nature - if B=(a,b,c) + E is less than 1-4-21 + G=3 and H=(HIGH, MEDIUM) the J displays 'Y'
Ive looked at versions of Vlookup and If criteria but im spiraling lol ... any help would be fantastic.
Im trying to populate column J (this year) based on the specific values in columns B (type), E (date last visit), G (score) and H (urgent) in the same row.
so in my simplistic nature - if B=(a,b,c) + E is less than 1-4-21 + G=3 and H=(HIGH, MEDIUM) the J displays 'Y'
Ive looked at versions of Vlookup and If criteria but im spiraling lol ... any help would be fantastic.