Vlookup formula result

[redspanna]

Hi all

Cell R6 = formula =(O6-SUM((N6-M6)*24*60)) to return a 'number' value
Cell S6 = formula =VLOOKUP(R6,U1:V50,2,FALSE)

so if returned value in R6 equals '20', lookup this value as shown and return value in lookup table.

However I keep getting a #N/A error

any ideas how to make the vlookup work??

thanks

 

[Akashwani]

Hi,

Is it?....

=IF(R6=20,VLOOKUP(R6,U1:V50,2,FALSE),"")

Ak