Posted to microsoft.public.excel.programming

Les Stout[_2_] Les Stout[_2_] is offline

external usenet poster

Posts: 396

Problem with "#N/A" after vlookup

Hi all, i am doing a series of Vlookups and if the value is not found i
get "#N/A" which i would like to replace with the text "Not found".
Any help or suggestion would be appreciated

With Cells(4, "I").Resize(numRows)
.Formula = "=VLOOKUP(A4," & myLookUpRng.Address(1, 1, xlA1,
True) & ",19,0)"
.Value = .Value
End With
Thanks in advance

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

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
correct syntax for nesting "if", "and", and "vlookup"....if possib	Christine	Excel Worksheet Functions	4	January 2nd 09 10:43 PM
vlookup problem, possibly due to "noise"	JPANDRE	Excel Worksheet Functions	2	November 16th 05 10:44 AM
IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")	Souris	Excel Programming	2	August 17th 05 05:33 AM
Problem with "On error resume next" with "custom VLookup"	Factivator	Excel Programming	3	July 20th 04 04:42 PM

All times are GMT +1. The time now is 03:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us