|
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) |
Getting a Result in vlookup dependent on another formula
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) |
| All times are GMT +1. The time now is 06:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com