Forum Discussion
Item formula
How do I enter an Item so each time a corresponding $ amount is put into a cell in the same row?
In the cell where you want the amount to appear, you enter a formula like
=IF(A1="desired entry",45.67,0)
there are other ways, more sophisticated ways, if you actually have, say, 20 different possible entries for cells in column A, each with its associated dollar amount. Then you could use VLOOKUP and a table with the text entries and the associated dollar amounts.
But you might want to give a more complete description here of what the bigger picture is, so a more robust and reliable answer could be created. What I've given you will work, but depending on the situation, on the importance of it, you want to make sure that there are no "holes" in the logic or design.