I would like to be able to enter a value in one cell and have it populate a value in another based on a 'key' from another tab. Currenlty Sheet1 contains static data but Sheet2 will have values entered related to the data but will be variable. For example, if I enter the number 1 in Cell A1, I want Excel to autopopulate B1 with 10.75.
How would I write this formula not using VBA?
I don't think you've provided enough information. The solution for your example is a simple IF statement in B1, but I don't think that's all you are looking for.
=IF(A1=1,10.75,"")
Please provide some more details. What do you mean by "based on a key from another tab"?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |