IFS getting #NAME? on Mac Excel V 16.37

[tomeegee]

I have a multi worksheet file in which I want to fill two boxes conditionally across workbooks drawing from two lists. When I got #NAME? I thought it was due to long, complicated formula with all the referenced sheets. So I simplified a trial on a blank page, and the result is the same. What am I missing?

[#2 · Accepted solution]

@tomeegee 

It's not IFS, but the text value A - it should be enclosed in ":

=IFS(B2="A",2,B2=B3,D3,...)

(Weird formula, by the way)

[#3]

@Hans Vogelaar 

(Smacks head) I figured that out about a minute after I posted. 

I have a golf tournament spread sheet and the handicaps get applied per person across games, so Name = Specific Course Handicap. This helps me just put in a name and the handicap auto populates.

Thanks for the response!