Thread: VLOOKUP NESTED
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tester Tester is offline
external usenet poster
 
Posts: 23
Default 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