IF statement, Simple Question

[jrwrita]

Hi All,

Say I have a Vlookup, and if it returns a value I want it to say TRUE or even my own term such as 'matched', and if the vlookup returns an #N/A I want a False or my own custom term. Is there anyway to do this?

Thanks.

 

[gaz_chops]

What is the value the lookup returns?

As in, is it a number or text?

 

[jrwrita]

What is the value the lookup returns?

As in, is it a number or text?

Lookup returning numbers

 

[gaz_chops]

Then try

=IF(ISNUMBER(VLOOKUP()),"True","False")

 

[stuartnico]

Just my way.....

SHEET 1

A	B	C
1	Peter	22.99
2	John	10
3	Craig	20
4	mark	19.99
5	Steven	13.55
6	Ralph	23.44
7	Roger	22.22

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

First way...

=IF(VLOOKUP(A1,Sheet1!B1:C7,2,FALSE)>15.99,"TRUE","FALSE")

Second Way

=IFERROR(IF(MATCH(A9,Sheet1!B:B,0),"TRUE"),"FALSE")

 

[gaz_chops]

Just my way.....

SHEET 1

A	B	C
1	Peter	22.99
2	John	10
3	Craig	20
4	mark	19.99
5	Steven	13.55
6	Ralph	23.44
7	Roger	22.22

<tbody>
</tbody>

First way...

=IF(VLOOKUP(A1,Sheet1!B1:C7,2,FALSE)>15.99,"TRUE","FALSE")

Second Way

=IFERROR(IF(MATCH(A9,Sheet1!B:B,0),"TRUE"),"FALSE")

The 1st one won't work if it doesn't find the lookup value. It will still return #N/A.