Posted to microsoft.public.excel.worksheet.functions

Debbie[_4_] Debbie[_4_] is offline

external usenet poster

Posts: 24

Vlookup problem

Hi!

The problem I am having is in the lookup table, sometimes row 5 is
empty. When it is, it puts a zero in my cell. I want it to be blank.
Can I do this? I have pasted my formula.

=IF(ISERROR(VLOOKUP($A7,BB!$A$1:$S$5000,5,FALSE)), "",VLOOKUP($A7,BB!$A
$1:$S$5000,5,FALSE))

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
Problem with Vlookup	Confused	Excel Worksheet Functions	10	April 23rd 09 07:20 PM
vlookup problem	Alessandro	Excel Discussion (Misc queries)	10	January 22nd 08 05:49 PM
vlookup problem	Jeanette	Excel Worksheet Functions	4	February 14th 07 07:18 PM
VLOOKUP Problem	uplink600	Excel Worksheet Functions	2	November 24th 05 03:57 PM
vlookup problem	idcreek	Excel Worksheet Functions	4	May 24th 05 01:07 PM

All times are GMT +1. The time now is 12:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us