Again, I'm probably doing this wrong. I need to return the value, which is an approval date, from column N on sheet two when; a) there is a match between the referenced cell in sheet one and column G from sheet two and b) That matched item reads "APPROVED in column M. the above is what I tried & it gives me the "Your Formula Missing a Parenthesis" error. All attempts I've made at filling in the missing parenthesis keeps giving me the wrong result.
Please Login or Register to view this content.
Last edited by xrajncajnx; 07-16-2014 at 11:47 AM.
Perhaps you wish:
=IFERROR(IF(VLOOKUP(C8,'SHEET 2'!G:M,7,FALSE)="Approved",VLOOKUP(C8,'SHEET 2!G:N,8,FALSE),""),"")
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
you left off the 2nd argument of the IFERROR, what to return if it's an error.
presumeably you want to return "" in that case.
The ,"" part you have in there is actually in the valueiffalse part of the IF (what to return if vlookup does not = "approved")
Try
=IFERROR(IF(VLOOKUP(C8,'SHEET 2'!G:M,7,FALSE)="Approved",VLOOKUP(C8,'SHEET 2!G:N,8,FALSE),""),"")
Try this...
Formula:
Please Login or Register to view this content.
don't forget to click *
That did the trick all, thanks...
And thank you Jonmo for the explaination.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks