V Vlookup and If Aug 31, 2009 #1 Is it possible to use both Hlookup or Vlookup and If statements in the same formula? If so, can someone provide an example? Thanks
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 Aug 31, 2009 #2 Hi, =if(A1>10,your vlookup formula,"") if the value is less than 10 it will leave a blank space this is what ,"" does
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 Aug 31, 2009 #3 Hi, Here is the most common example: =IF(ISNA(VLOOKUP(A1,R1:S100,2,FALSE)),"",VLOOKUP(A1,R1:S100,2,FALSE))
Hi, Here is the most common example: =IF(ISNA(VLOOKUP(A1,R1:S100,2,FALSE)),"",VLOOKUP(A1,R1:S100,2,FALSE))
