

VLOOKUP Exact Match Lookup Table with Named Range
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.