So this is two problems in one:
-
How do I make a formula in google sheets that says if a cell is a specific string then it applies one formula, but if it is not the specified string then it applies a different formula?
-
How do I specify the cell next to a previously specified cell?
context:
I’m a conlanger, which means that I make constructed languages. I’m trying to make an interactive verb table that conjugates a verb how I want to. In the lexicon sheet (the dictionary), it says next to the verb if it is regular or irregular. So I want to make it check if the verb is regular by finding the verb in the lexicon sheet and looking at the cell to the right of it and if it is then it does a concatenate formula to add a prefix to it, but if it’s irregular then it will pull the value from a separate sheet. Additionally, how do I specify the column and row separately but have sheets recognise it as the coordinates of a cell (for example, doing a sum that says that A will be the column and 3+3 will be the row so then it will recognise A6 as the cell)?
I haven’t tried much because I have absolutely no clue how to do it.