IF Function - vlookup / true false

[RJB78]

Hello. Thank you in advance for the assistance.

I have a formula that I am trying to update. Currently, the formula references other data points that are on the same worksheet as the formula. The datapoints use vlookups to display the data from other input worksheets. I would like to convert the formula so instead of looking for the value in the same worksheet, it will go directly to the data input worksheet.

The formula is below. For example, in the bolded section; currently in cell BG2 is a vlookup that will return: 'A+, A, A-, etc'. How can I rewrite the formula to find the letter grade in a different workbook, lets call it 'GRADES', and allow the OR formula to be true or false based on the result.

=IFERROR(IF(AND((($T2*1000)*0.5)>((RF!$AF$38*0.04)/$H2),$D2<>"LP",OR($BG2={"A+","A","A-","B+","B","B-","NR"}),$Q2>=4,OR($BD2="Yes",BE2>=4,BF2=4)),"Yes","No"),"No")

 

[DanteAmor]

currently in cell BG2 is a vlookup

OR($BG2={"A+","A","A-","B+","B","B-","NR"})

Replace $BG2 in the "big" formula with the formula you have in cell BG2.

For example:

VLOOKUP(BH2,Sheet2!$A$2:$B$8,2,0)

OR(VLOOKUP(BH2,Sheet2!$A$2:$B$8,2,0)={"A+","A","A-","B+","B","B-","NR"})

This is an example, never in a million times will I guess what formula you have in cell BG2, so change my formula to your actual formula.