| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested VLOOKUP in IF statement
=IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0)
Hi all, Above is my simple nested vlookup statement. The problem is, it may be too simple. Basically I'd like for this vlookup statement to run when the condition is met. When the condition is true, the result is "=VLOOKUP(H4,$B$5:$C $11,2,FALSE)" printed in the cell as a value instead of returning the formula result. I've tried the following without success... =IF(H5=$C$2,"VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) <--- without the = =IF(H5=$C$2,=VLOOKUP(H4,$B$5:$C$11,2,FALSE),0) <--- without the "quotes" Is there something I'm doing wrong? Cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nested VLOOKUP in IF statement
=IF(H5=$C$2,VLOOKUP(H4,$B$5:$C$11,2,FALSE),0)
" wrote: =IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) Hi all, Above is my simple nested vlookup statement. The problem is, it may be too simple. Basically I'd like for this vlookup statement to run when the condition is met. When the condition is true, the result is "=VLOOKUP(H4,$B$5:$C $11,2,FALSE)" printed in the cell as a value instead of returning the formula result. I've tried the following without success... =IF(H5=$C$2,"VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) <--- without the = =IF(H5=$C$2,=VLOOKUP(H4,$B$5:$C$11,2,FALSE),0) <--- without the "quotes" Is there something I'm doing wrong? Cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nested VLOOKUP in IF statement
On May 14, 6:38*pm, minli wrote:
=IF(H5=$C$2,VLOOKUP(H4,$B$5:$C$11,2,FALSE),0) " wrote: =IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) Hi all, Above is my simple nested vlookup statement. The problem is, it may be too simple. Basically I'd like for this vlookup statement to run when the condition is met. When the condition is true, the result is "=VLOOKUP(H4,$B$5:$C $11,2,FALSE)" printed in the cell as a value instead of returning the formula result. I've tried the following without success... =IF(H5=$C$2,"VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) *<--- without the = =IF(H5=$C$2,=VLOOKUP(H4,$B$5:$C$11,2,FALSE),0) * <--- without the "quotes" Is there something I'm doing wrong? Cheers- Hide quoted text - - Show quoted text - Thank you. Works a charm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested hlookup/vlookup (possibly just an if statement though?!?) | Excel Discussion (Misc queries) | |||
| Nested VLOOKUP in IF statement | Excel Programming | |||
| Nested if statement and vlookup problem | Excel Programming | |||
| Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
| Retry: VLOOKUP nested in IF Statement | Excel Worksheet Functions | |||
Hybrid Mode
