Enter a cell value to populate a cell value from another tab

March 13, 2013 at 21:29:58
Specs: Windows 7
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?


See More: Enter a cell value to populate a cell value from another tab

Report •


#1
March 14, 2013 at 04:31:34
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.


Report •
Related Solutions


Ask Question