Using Hlookup and If Statments Simultaneously

  • Thread starter Thread starter Vlookup and If
  • Start date Start date
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
 
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,

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
Nesting Lookup Functions 4
Hlookup with Merged cell as look up value 1
using hlookup to reference a column in a vlookup formula? 3
Hlookup, range_lookup parameter 1
HLookUp 1
Index / Hlookup 1
MATCH to return row number not working in HLOOKUP 2

Back
Top