| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use formula result in vlookup | Excel Discussion (Misc queries) | |||
| Why do I get #NA as my result when I write a vlookup formula? | Excel Worksheet Functions | |||
| VLOOKUP FORMULA IS DISPLAYED AS THE RESULT | Excel Discussion (Misc queries) | |||
| VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
| Formula help. Different result dependent on answer | Excel Worksheet Functions | |||
Linear Mode
