Using Hlookup and If Statments Simultaneously

V

Vlookup and If

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

Eduardo

Hi,

=if(A1>10,your vlookup formula,"")

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

Shane Devenshire

Hi,

Here is the most common example:

=IF(ISNA(VLOOKUP(A1,R1:S100,2,FALSE)),"",VLOOKUP(A1,R1:S100,2,FALSE))
 
Top