Hey guys,
I'm trying to create a spreadsheet which consolidates a lot of other data, reducing duplicate inputs.
basically the situation is this:
If a cell B1 has a value (>1), cell C1 has a name, the same name as A1. I'm using this formula:
=IF(B1>=1,"Apple","")
The trouble is I need the word "Apple" to change when the input in A1 changes. So I need a formula similar to
=IF(B1>=1,"A1","")
But obviously the above doesn't work!
Any help would be much appreciated, I've spent at lot of time playing around with this but to no avail!
Bookmarks