Excel - Functions

Copper Contributor

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



Screenshot 2023-08-28 140149.png

2 Replies


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)


=XLOOKUP(A10, $A$2:$A$6, $B$2:$B6, "")

Fill down.

Thank you! this is exactly what I needed!