Can somebody please provide a formula for the following.....i'm having a heck of a time.
If value in column E on Sheet1 equals value in column D on Sheet2 and Column D contains "FC T" on sheet1 and Column Q contains "FC C & D" on sheet2 then return Cell A1 from sheet2
Administrative Note:
- We would love to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread
- Please PM me when complete and this post will be removed which will reset the replies to zero…
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
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
Might be something like this:
=IF(AND(Sheet1!E1=Sheet2!D1,Sheet1!D1="FC T",Sheet2!Q1="FC C & D"),Sheet2!A1,"")
It might be helpful to include a sample workbook (with mock data) that includes the outcome you are trying to reach.
Last edited by jeffr27; 09-05-2013 at 09:38 AM.
jeff, I see nowhere where I was pointing out confusion in the thread, I was requiring a thread title change. And you have been around long enough to know not to post when this kind of request has been made!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks