How to use multiple supp table personalization in Email/SMS campaign workbook for the same customer

We have scenario to use multiple supp table in one Email/SMS campaign workbook to use Personalization for the same customer based on RANK column value.
Ex:- Customer_ID 1234 is present in Rank1_Supp_Table and Rank2_Supp_Table and both the table has column as "Header_Message" and "Rank"
For Customer_ID 1234 if the Rank="1" then need to use Rank1_Supp_Table "Header_Message" else if the Rank="2" then use Rank2_Supp_Table "Header_Message"