ok so I have a spreadsheet which has 3 different names in a drop down list well i want different values based on the name selected while if for the selected name is blank its value is "" but also doesn't interfere with the other names on the list.... here is what i have so far

=IFS(
NAME="John Doe",John_GAS_SATURDAY_INITIAL,
NAME="Jane Doe",Jane_GAS_SATURDAY_INITIAL,
NAME="Jean Doe",Jean_GAS_SATURDAY_INITIAL)

ideal results is

John Doe Gas is empty return ""
Jane Doe gas is $5.00 return "$5.00"
Jean Doe gas is $6.00 return "$6.00"

previous attempts would return "" for the selected name even when giving the value because gas for the 1st name tested was empty...

any help would be appreciated!