Forum Discussion
IF Function
I'm trying to assign a number value to a previously assigned rank. For instance, ranking #1 receives a value of 30, ranking #2 receives a value of 27, ranking #3 receives a value of 24, etc. I can'...
But%20you%20showed%20how%20to%20do%20it%20using%20a%20single%20cell%20of%20%22E1%22.%20%20How%20do%20I%20look%20at%20the%20other%20cells%20like%20E2%2C%20and%20E3%2C%20etc%20and%20still%20keep%20the%20same%20search%20criteria.%20%20I%20even%20tried%20to%20use%20the%20%22%24%22%20before%20the%20search%20criteria%20and%20couldn't%20seem%20to%20get%20it%20to%20work%20the%20same%20way
- =LOOKUP(E1,$A$2:$A$11,$B$2:$B$11)
Using the $ it locks in that reference. This is called absolute referencing. Without the $ it's called relative referencing. There are 4 types of [A1 notation] referencing:
A1 - column and row are relative
$A1 - column is absolute, row is relative
A$1 - column is relative, row is absolute
$A$1 - column and row are absolute
When you copy these types of formulas down/across with relative referencing, those references will move as the destination cell moves. Conversely, as you move the formulas, those absolute parts of cell referencing will not move.
In the above formula, the ranges ($A$2:$A$11,$B$2:$B$11) will not move. Column A should house your rank values, column B should house the return/associated values.
