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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hlookup & Vlookup 2
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Nesting Lookup Functions 4
Hlookup with Merged cell as look up value 1
HLOOKUP & VLOOKUP Combinded 4
using hlookup to reference a column in a vlookup formula? 3
Hlookup, range_lookup parameter 1
use Hlookup to look up two or more values 5

Top