| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP NESTED
Hi - this is my formula but it returns N/A. Where have I gone wrong please?
=IF(I620,I62*(VLOOKUP((VLOOKUP(C62,$J$43:$M$56,2, TRUE)),'Control Sheet'!$F$29:$G$31,2,TRUE)),0) Basically, if I62 has a value then i want to multiply it by a varaible percentage which is determined by the vlookup formula. The nested Vlookup finds the value against the name in C62 to use in Control Sheet to determine the percentage rate. TIA Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with nested IF | Excel Discussion (Misc queries) | |||
| Can Someone Help me With a Nested VLOOKUP | Excel Discussion (Misc queries) | |||
| Nested vlookup | Excel Discussion (Misc queries) | |||
| nested ifs or vlookup or ? | Excel Discussion (Misc queries) | |||
| Nested vlookup? | Excel Worksheet Functions | |||
Threaded Mode
