|Let's say you start with this:|
2 abc 1
3 wse 2
4 xyz 5
5 awe 3
This formula will return the value from Column L corresponding to the number in CY1, assuming that the number is found in CY2:CY5. If it isn't, the formula will return #N/A.
The INDEX function returns the value from the array L2:L5 based on the row_num and column_num arguments.
The MATCH function is used to determine the row_num argument by matching the value in CY1 within the array CY2:CY5.
The #N/A can be eliminated with an IF(ISNA( function.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.