Hi,

Here is the most common example:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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