

VLOOKUP Range Lookup Table with Absolute References
Roman Kondratiuk
The IF function is a logical category function that returns one value if a condition is met and another value if it is not met.
The IF function is one of the most widely used and practically useful functions in Excel.