VLOOKUP and IF statement query
Hi
I have a workbook with several sheets, I have an upload sheet that is referencing to several other sheets.
Problem I have is, I need to pull through when I field is blank and fill with nothing rather N/A or 0.
Current VLOOKUP statement: =VLOOKUP('Petty Cash Posting Docket'!G17,'General Ledger Accounts'!A:B,2,FALSE)
However I need this to say if this is BLANK then enter " ", guessing with an IF statement
Many thanks
Louise 'my 1st post'
will solve the NA.
Please Login or Register to view this content.
should solve both.Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thank you mikeTRON, that has done the trick
That has fixed this but if I apply to cells where information should be pulled through, this is also pulling through blanks
It would help if you were to attach a sample worksheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
^ Attaching a sample workbook is always the easiest.Originally Posted by Glenn Kennedy
Attached workbook, thanks
Last edited by LouiseC; 03-16-2015 at 11:50 AM.
I am still not exactly sure what you are trying to do but maybe this is what you are asking for?
Please Login or Register to view this content.
=IF(NOT(ISBLANK('Source Data'!B6)),VLOOKUP('Petty Cash Posting Docket'!G7,'General Ledger Accounts'!A:B,2,FALSE)," ")
this works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks