View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Using Hlookup and If Statments Simultaneously

Hi,

=if(A110,your vlookup formula,"")

if the value is less than 10 it will leave a blank space this is what ,"" does

"Vlookup and If" wrote:

Is it possible to use both Hlookup or Vlookup and If statements in the same
formula? If so, can someone provide an example?
Thanks