IF THEN Statements In Google Sheets

[@LucasLearnz]

Let me know if there is anything in Google Sheets you want me to cover!

[@rmnds]

I want to set up a table in sheets where one column is countries and another column is their respective VAT rates. IS it possible to set up an IF condition where I enter the country into the column/row and Sheets would know the respective VAT rate to enter in the VAT column? So there would be many countries and a VAT rate for each.

[@LucasLearnz]

@@rmnds This was fairly complicated. Based on what I found there is no way for Google Sheets to just "know" that on its on. However, you could copy paste in a table with countries and their VATs and then use =XLOOKUP to find the specific VAT for each country somewhere else in the sheet. I might make a video on this in the future but in the meantime, I hope that helps!