Thread: Getting a Result in vlookup dependent on another formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jhyatt jhyatt is offline
external usenet poster
  
Posts: 61
Default Getting a Result in vlookup dependent on another formula
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)

Reply With QuoteReply With Quote