Posted to microsoft.public.excel.worksheet.functions

CWH

external usenet poster

Posts: 4

=IF(NOT(ISNA(VLOOKUP Function

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,FAL SE))),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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF, ISNA & VLOOKUP	Sara	Excel Worksheet Functions	5	November 14th 08 04:16 AM
Vlookup - ISNA function	Eduardo	Excel Discussion (Misc queries)	4	September 24th 08 06:10 PM
If statement with Vlookup - including ISNA function to compare two columns from different worksheets	nakliwala	Excel Worksheet Functions	3	September 25th 07 09:30 AM
Using VLOOKUP (ISNA) function to compare 2 columns on different worksheets in excel	nakliwala	Excel Worksheet Functions	4	September 25th 07 08:17 AM
if isna and vlookup together	tina	Excel Worksheet Functions	2	January 20th 05 01:06 PM

All times are GMT +1. The time now is 06:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us