Posted to microsoft.public.excel.misc

external usenet poster

Posts: 83

=IF(ISNA + VLOOKUP?

Hi, i have a lookup i'm currently using; "=VLOOKUP(A3, ELMAX, 2,)" I want to
expand this formula to include an IF(ISNA aspect as when the value being
looked up doesn't occur in the lookup table i am getting #N/A!'s and want to
have them come through as zeros...any thoughts?

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
I need help with a IF(ISNA with vlookup	LAB	Excel Worksheet Functions	5	July 14th 08 11:28 PM
vlookup, IF, and ISNA	MMBOLI	Excel Discussion (Misc queries)	2	August 17th 06 04:53 PM
isna vlookup	Tim	Excel Discussion (Misc queries)	2	April 3rd 05 11:23 AM
ISNA and VLOOKUP	Chris Kellock	Excel Worksheet Functions	3	March 12th 05 07:05 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 02:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us