TYPE function

I

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
 
M

Mike H

Maybe,

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top