=IF(NOT(ISNA(VLOOKUP Function

C

CWH

I am using Excel 2003

I am trying to produce a summary shett from five differnet worksheets.

I am using the following function
=IF(NOT(ISNA(VLOOKUP(E7,Tests!D1:Tests!S147,18,FALSE))),VLOOKUP(E7,Tests!D1:Tests!S147,18,FALSE),"").

It works fine until I reach 18 and above and it returns #REF!.

Does this formula not work after 17 or is there another formula that I
should be using.

Colin
 
R

RonaldoOneNil

It should not work for 17 either because the range D to S is only 16 columns.
Your formula should also look like this.

=IF(NOT(ISNA(VLOOKUP(E7,Tests!D1:S147,16,FALSE))),VLOOKUP(E7,Tests!D1:S147,16,FALSE),"").
 

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

IF, ISNA & VLOOKUP 5
isna vlookup #n/a but not false 1
I need help with a IF(ISNA with vlookup 5
vlookup returning Errors (ISNA formula) 3
ISNA with VLOOKUP against 2 locations 7
Part of VLOOKUP not working 4
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA 6
if isna and vlookup together 2

Top