Good Day Folks,
I have an issue whereby I am trying to edit my formula and insert an IF statement.
The formula is:
=IFERROR(INDEX('Data - CURRENT'!$B$2:$B$2440,MATCH(LARGE('Data - CURRENT'!$BC$2:$BC$2440,ROW(K1)),'Data - CURRENT'!$BC$2:$BC$2440,0)),"")
However, the issue I am having is that I only want responses based on "IF" one of the cells in excel = a certain value:
'Data - CURRENT'!$AY:$AY="Y"
Can someone please help me sort this out?
Thank you in advance,
Andrew
I *think* this does what you want:
Does it?
Please Login or Register to view this content.
Try this...
=IFERROR(INDEX('Data - CURRENT'!$B$2:$B$2440,MATCH(LARGE(('Data - CURRENT'!$BC$2:$BC$2440,ROW(K1))*('Data - CURRENT'!$AY:$AY="Y")),'Data - CURRENT'!$BC$2:$BC$2440,0)),"")
untested
edit: is there an echo in here, Ron?
lol
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
Hi Ron and Ford - thank you to you both for your help...works a treat!! Really appreciate your responses.
Im happy it worked for you, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks