You could simplify the IF:

=IF(Saturday!C1=7,Saturday!B1,OFFSET(Saturday!$C$1 ,,7-Saturday!C1))

The N/A means there is no match: are all fields (A34:A76) formatted as date?
Is A1 formatted as Date?

"jhyatt" wrote:

i am trying to get vlookup to look up the result of a formula in A1 but i
keep getting an error n/a. the formula in a one is as follows.

=IF(Saturday!C1=6,Saturday!D1,IF(Saturday!C1=5,Sat urday!E1,IF(Saturday!C1=4,Saturday!F1,IF(Saturday! C1=3,Saturday!G1,IF(Saturday!C1=2,Saturday!H1,IF(S aturday!C1=1,Saturday!I1,Saturday!B1))))))

Resulting in the date for saturday of the current week. 1-Sep
and the formula in B2 is as follows.

=VLOOKUP($A$1,$A$34:$J$76,10,FALSE)