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!
Hi Samantha,
Can you please attached the photos again, or even better a sample Excel file with a few examples of the data you want to lookup. You need to press the yellow 'start upload' button after selecting your file.
Mynda
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.
I have attached my images. I am sorry my upload did not work yesterday and I did not notice that.
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
I have attached a dummy file. there is 3 sheets and sheet 3 is an example of what the goal is.
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
