Russell Pearce Russell Pearce is offline

Junior Member

Posts: 2

Quote:

Originally Posted by Spencer101

Hi Russell,

You'll be glad to hear this is easy enough to sort out.

Taking for example the formula you have in cell I2, change it from =VLOOKUP(H2,AV!$A$1:$B$6,2,FALSE) to =IFERROR(VLOOKUP(H2,AV!$A$1:$B$6,2,FALSE),"") and copy to all relevant cells (Purple ones in columns G to X). That should solve the problem.

Let me know if it doesn't, but it did when I tested it.

Thank you so much! Perfect!!!!!

Russell

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
Averages	sailor	Excel Discussion (Misc queries)	3	September 8th 09 05:13 PM
Averages	Marvin	Excel Discussion (Misc queries)	5	July 4th 08 09:34 AM
Averages	Bec[_3_]	Excel Worksheet Functions	3	September 12th 07 05:20 AM
Averages	Beth	Excel Worksheet Functions	4	March 9th 06 08:19 PM
Help with averages please	amerkarim	Excel Worksheet Functions	5	September 29th 05 04:03 AM

All times are GMT +1. The time now is 08:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us