Getting a Result in vlookup dependent on another formula

J

jhyatt

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,Saturday!E1,IF(Saturday!C1=4,Saturday!F1,IF(Saturday!C1=3,Saturday!G1,IF(Saturday!C1=2,Saturday!H1,IF(Saturday!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)
 
T

Toppers

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls Help - blank cell/formula issue 7
Excel Dates 3
No of Days between two dates and offset formula 4
VBA Coding Help for Beginner 0
incrementing a date that the user has entered? 4
Adjusting Date Results 7
Conditional Formatting Formula 3
IF statement based on True/False that activates a certain list box 1

Top