Okay, now that I had the other figured out, I am told there is more I need.

I need a formula that tells me to look at one place IF my criteria is met,
otherwise look here for my information: Here is my formula that is returning
FALSE or #REF!:

=IF($F$2="FMLA",(INDEX('Look Up Sheet'!$B$2:$E$5,MATCH($B$5,'Look Up
Sheet'!$A$2:$A$5,0),MATCH($A$5,$B$1:$E$1,0),INDEX( 'Look Up
Sheet'!$B$6:$E$9,MATCH(B5,'Look Up Sheet'!$A$6:$A$9,0),MATCH(A5,'Look Up
Sheet'!$B$1:$E$1,0)))))

This is my scenario...

I have 2 worksheets, one is my form and the other is my lookup for all
information.

I want to look at F2 to see if it says FMLA or CFRA (or any other type of
leave). If it says FMLA, I want it to look at the other two matches and give
me the corresponding amounts, if not, give me the corresponding amounts in
the other section I specified. Here is my data:

A B C E
E F
1 HMO PPO DENTAL VISION
2 Employee Only $- $22.19 $15.32 $5.06
FMLA
3 Employee & Spouse $110.85 $159.67 $29.50 $8.57
4 Employee & Child $73.47 $116.75 $31.00 $8.65
5 Employee & Family $181.88 $249.67 $53.69 $14.35
6 Employee Only $269.20 $291.39 $17.46 $5.06
OTHER
7 Employee & Spouse $592.24 $641.06 $33.43 $8.57
8 Employee & Child $524.93 $568.20 $33.02 $8.65
9 Employee & Family $855.42 $890.20 $58.05 $14.35