TYPE function

[Iriemon]

I have the following formula but it is not gving me the results I am looking
for:

=IF(TYPE(VLOOKUP(V2,'thread
lookup'!$R$17:$S$24,2,FALSE)=16),1,VLOOKUP(V2,'thread
lookup'!$R$17:$S$24,2,FALSE))

The idea is to look for the value in V2 in my lookup table and if the result
is #N/A then return the value 1, otherwise lookup the value in V2 in my
lookup table.

All this formula is returning is 1 for everything.

Can anyone tell me where the formula is incorrect?

Thanks

 

[Mike H]

Maybe,

=IF(ISNA(VLOOKUP(V2,'Thread lookup'!R17:S24,2,FALSE)),1,VLOOKUP(V2,'Thread
lookup'!R17:S24,2,FALSE))

Mike

 

[Max]

One usual way is to use ISNA, viz:
=IF(ISNA(VLOOKUP(V2,'thread lookup'!$R$17:$S$24,2,0)),1,VLOOKUP(V2,'thread
lookup'!$R$17:$S$24,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik

 

[Iriemon]

THANKS GUYS!

Perfect!