Excel - Functions

[LexiRae]

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%.

[#2]

@LexiRae 

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.

[#3]

Thank you! this is exactly what I needed!