Forum Discussion
Excel - Functions
I need help creating a function that will generate the Employer match set amounts to rows below. Example, if Employee side shows 4% I need the next column to generate 3.5%.
Let's say the first list is in A2:B6 (with headers in row 1).
In B10:
=VLOOKUP(A10, $A$2:$B$6, 2, FALSE)
or
=XLOOKUP(A10, $A$2:$A$6, $B$2:$B6, "")
Fill down.
Thank you! this is exactly what I needed!