I have this file: C:\Dropbox\class\TEMPLATES\report.xlsm where if I typed a number in cell F28, then cell G27 shows the value of a cell on column C of C:\Dropbox\main\grades.xlsm, but only if the number I type in F28 of report.xlsm is found on column A of grades.xlsm, if not then G27 shows the text 'ABSENT'.

So I used this formula:

=IF(ISNA(VLOOKUP(F28,'C:\Dropbox\main\[grades.xlsm]GRADES'!$A:$C,1,FALSE)), "ABSENT", VLOOKUP(F28,'C:\Dropbox\main\[grades.xlsm]GRADES'!$A:$C,1,FALSE))

The problem is that G27 keeps showing 'ABSENT' even if the number is correct on F28 of report.xlsm and indeed located as well in column A of grades.xlsm

What am I missing?

By the way, I'm using DropBox App (just in case this has anything to do with this issue I'm having).

Also, I do not know VBA.

What do I do???? Please help.