
Active Member

June 24, 2019

I have a work book with 2 sheets. one sheet uses a vba code to pull from an outlook folder. The information that comes in from the outlook folder is the team members name, the date of the response and the voting option they selected. on the second sheet is a column with all team members names, a column for which ever voting selection was made and a few others. at the top of the row for where the voting selection goes is that current days date. What i need is a function for if the date in sheet one matches the date on sheet 2 to return the correct voting selection.
I have attached photos that are hopefully helpful. For sheet 1 the voting selection if the number that is found in column C.
I really hope someone is able to help me figure this out. Thank you!


July 13, 2016

Hi Sammantha,
As Mynda pointed out, it is a little tricky without an example!
I had a go at what I thought you might have meant.
Attached is an example sheet where you might be pasting/dumping data into sheet 1 which has the columns of Name;Date;Vote
Then the second sheet will look through those values and find the vote for each person or each date, and place the data in there.
Please advise if this is close to what you are after?
You will note that the formulas in Sheet2 are array formulas, so you need to use Ctrl+Shift+Enter whenever you finish editing one of them.


July 16, 2010

Hi Samantha,
Can you please upload a sample Excel file as it's difficult to follow from the images and I don't have time to try and recreate all of your data, which I suspect is why no one else has answered your question either. It can just be some dummy data in a file with the formuals you're already using and your desired result.
Thanks,
Mynda


July 16, 2010

Hi Samantha,
Thanks for sharing your file. You can use INDEX & MATCH array formula for this as explained here. See sheet 3 of the example file attached.
Mynda
1 Guest(s)
