Vlookup + IF or a better way ??? Please!

[HuskyJones]

Hey folks
Have a column (R) to populate with data depending on the answers in several other columns.

I've started it with ....
=IF(S5<>"",VLOOKUP(S5,'Look Up Tables'!$T$2:$V$29,3,FALSE),"********")

Then in the ******* I need these options from cols AA, O & P to enter the correct treatment
AA + O + P = treatment
950 + First + Attended = pre assess
950 + Follow up + Attended = pre assess
950 + Telephone + Attended = Telephone Follow-Up Appointment
301 + First + Attended = First Attendance Single-Professional
301 + Follow up + Attended = Follow up singe professional
120 + First + Attended = First Attendance Single-Professional
120 + Follow up + Attended = Follow up singe professional

 

[steve the fish]

If i understand then create another look up table and concatenate the 3 cells together seperated by | eg:

=VLOOKUP(AA5&"|"&O5&"|"&P5,'Look Up Tables'!$T$40:$V$50,2,FALSE)

then in your look up table have 950|First|Attended and pre assess etc

 

[HuskyJones]

perfect! thank you so much