# using IF and VLOOKUP formulas together

#### calypsooo

##### New Member
I've been trying to come up with a solution for the gradebook I'm setting up since hours with no luck so far. I give up. I bet it's something you Excel-gurus could deal with easily, so here's what I'm trying to do and what is not working.

There are two different columns displaying different criteria (one for final exam, the other for overall average), and a "pass/fail" column referring to a simple table in another worksheet "0-Fail, 70-Pass" when calculating the result by VLOOKUP, based on the overall average. But I need to make the "pass/fail" column account another variable, the minimum required points on final exam (60), which is different from the minimum pass mark (70). To put it in a different way, even if a student's overall average is above 70, they have to "Fail" if their mark on the final exam is below 60.

Is it possible to do this by using IF and VLOOKUP functions together? If so, how am I supposed to write the formula? I was thinking maybe something like "IF=D>=60,VLOOKUP(F; Table!\$B\$10:\$D\$12; 2; TRUE) would work, but obviously it doesn't.

Help.

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
post a small sample of data (using fake information of course) to help us have a better picture of the data layout

Replies
4
Views
97
Replies
9
Views
121
Replies
15
Views
484
Replies
8
Views
582
Replies
2
Views
165

1,196,508
Messages
6,015,613
Members
441,906
Latest member
gafoor

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back