Kevin

Posts: n/a

VLookup Return Value

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!

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
Can vlookup return multiple matches in a single cell?	cchristensen	Excel Discussion (Misc queries)	3	December 2nd 04 01:56 AM
VLOOKUP, I think	Matt T	Excel Worksheet Functions	1	November 18th 04 07:07 PM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM
How to look up and return multiple values	Wendy	Excel Worksheet Functions	3	November 3rd 04 04:32 PM
vlookup and IF function	cambridge	Excel Worksheet Functions	5	October 28th 04 08:29 PM

All times are GMT +1. The time now is 05:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us