View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default CHOOSE & VLOOKUP; Weird Behavior

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