VLOOKUP??

[Shani]

Hi. I'm using the VLOOKUP function, and in the Range
lookup I have FALSE, because I want the criteria to match
exactly. However, if the data does not match exactly I
want the column to be left blank, not come back with
#N/A. What can I put in the Range lookup to accomplish
this?

Thanks!!

 

[RagDyer]

Here's an example, where you can plug in your references.
BTW, zero (0) is the same as "False".

=IF(ISNA(MATCH(D2,A2:A100,0)),"",VLOOKUP(D2,A2:C100,3,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi. I'm using the VLOOKUP function, and in the Range
lookup I have FALSE, because I want the criteria to match
exactly. However, if the data does not match exactly I
want the column to be left blank, not come back with
#N/A. What can I put in the Range lookup to accomplish
this?

Thanks!!