Hi just a question from a newbie :)
Hi there!, I'm kinda new to this forum so... here is my simple question....
I'm using a Vlookup function so instead of it returning "0", i want it to return a "blank" cell.
I tried using formulas from the forum but it doesn't work or i just cant seem to know where to properly put/place it.
here is my code.
=IFERROR(VLOOKUP(ROWS($B$7:B7),Database!$A$2:$W$1000,COLUMNS($B$7:B7)+2,FALSE),"")
Your help is very much appreciated.
Thank You!
Hi and welcome to the forum
deleted the rest of my text, see Fotis' post
Last edited by FDibbins; 01-24-2014 at 02:35 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Welcome to the forum.
We'd like to help you but first..
Pls take some minutes to read forum rules and specially-in this case- rule#1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks