Vlookup with multiple IF statements

Hello,

I'm using a vlookup and would like to return a message in the cell based on what number the vlookup returns. I've started one where if 4 is in the cell it returns "blocked". Example:

=IF(VLOOKUP([@[PART NUMBER]],Table_Query_from_DATA[#All],4,FALSE)=4,"blocked") This formula works.

However, I'd like to add the following formulas into the one above so that I can return different values based on numbers zero through 8.

=IF(VLOOKUP([@[PART NUMBER]],Table_Query_from_DATA[#All],4,FALSE)=0,"")
=IF(VLOOKUP([@[PART NUMBER]],Table_Query_from_DATA[#All],4,FALSE)=1,"no shipments")
=IF(VLOOKUP([@[PART NUMBER]],Table_Query_from_DATA[#All],4,FALSE)=2,"no receipts")
etc.

Any advice? Thank you

Use a table with your output text e.g A1:A9

Message 0
"No shipments"
"No receipts"
Message 3
Message 4
Message 5
Message 6
Message 7
Message 8


=IFERROR(INDEX(A1:A9,"vlookup formula.")+1,"")

i.e.

=IFERROR(INDEX(A1:A9,VLOOKUP([@[PART NUMBER]],Table_Query_from_DATA[#All],4,FALSE)+1,"")

Thank you protonLeah, this worked perfectly. I've never used CHOOSE before.