dgenty

Junior Member

Posts: 2

IF(ISERROR(VLOOKUP help required

Hi I am trying to Get a IFERROR translated so it works with office 1997. I heard this can be done with IF(ISERROR but I cant get it to work.

Below is the IFERROR I am using which works fine. It does a vlookup on 2 different worksheets if it cant find the target on the first sheet.

=IF((F10=0),"",IFERROR(VLOOKUP(F10,'General Skill'!A:B,2,FALSE),VLOOKUP(F10,'Map point Exceptions'!A:H,6,FALSE)))

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
ISERROR on VLOOKUP	b1llt	Excel Worksheet Functions	3	March 30th 10 03:24 PM
vlookup with iserror	[email protected]	Excel Programming	4	April 22nd 06 05:13 PM
Iserror and vlookup	T De Villiers	Excel Worksheet Functions	1	January 27th 06 04:00 PM
ISERROR VLOOKUP	Carole O	Excel Worksheet Functions	1	June 1st 05 02:08 AM
Iserror and Vlookup	ShineboxNJ	Excel Worksheet Functions	1	November 18th 04 11:31 PM

All times are GMT +1. The time now is 04:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us