I wonder if your array needs to be listed in alphabetical order.

"ryguy7272" wrote:

I entered the following two functions (below) into my spreadsheeet and get
the results I expect, except if I enter "SELLER" or "TAX INSURANCE" into
B276. Does anyone have any thoughts as to why this could be?

=CHOOSE(MATCH(B276,{"BUYER";"SELLER";"TAX INSURANCE";"CONTINGENT
INSURANCE";"DEED REPLACEMENT";"CONTINGENT DEED REPLACEMENT"},1),"FIFTY-FIFTY")

=VLOOKUP(B276,A312:A319,1)


Cordially,
Ryan---
--
RyGuy