VLOOKUP??

S

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!!
 
R

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!!
 
Top