Posted to microsoft.public.excel.worksheet.functions

Belinda7237 Belinda7237 is offline

external usenet poster

Posts: 106

Vlookup Problem

My Vlookup formula is:

=VLOOKUP(D81,'Week 2 Dataset'!G:O,9,0)

How would I write this differently so that when a result doesnt match i get
the cell to be left blank instead of #NA?

I need to incoprate an if but am not sure how to write it?

Thanks!

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
VLOOKUP Problem	Leslie	Excel Worksheet Functions	5	April 10th 08 06:43 PM
VLOOKUP problem	GKW in GA	Excel Discussion (Misc queries)	2	April 8th 08 06:47 PM
Vlookup problem	SoCal Rick	Excel Worksheet Functions	1	November 1st 07 04:06 AM
Vlookup problem	Graham Haughs	Excel Worksheet Functions	3	February 1st 06 07:54 PM
vlookup problem	idcreek	Excel Worksheet Functions	4	May 24th 05 01:07 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us