mitchell36
New Member
- Joined
- Oct 24, 2018
- Messages
- 5
Hi,
I have this formula that checks a date an if the date matches on another sheet. If th date matches the informaytio is posted in hat cell to another cell on a different page. My issue is I need for the formula to look at the date matc the date and post h inormatinin a ew cel on new sheet a continue to look down each column doing the same thing.
=VLOOKUP(B9,root,2,0)
so the formula looks at B9 which is the date column it then goes to the sheet named root checks the corresponding date and then posts the information on the first sheet. I need the formula
to look at the next column in root and do the same. See example below
<tbody>
</tbody>
I have this formula that checks a date an if the date matches on another sheet. If th date matches the informaytio is posted in hat cell to another cell on a different page. My issue is I need for the formula to look at the date matc the date and post h inormatinin a ew cel on new sheet a continue to look down each column doing the same thing.
=VLOOKUP(B9,root,2,0)
so the formula looks at B9 which is the date column it then goes to the sheet named root checks the corresponding date and then posts the information on the first sheet. I need the formula
to look at the next column in root and do the same. See example below
28/12/2018 | Majestic Princess |
28/12/2018 | Boxing Day - 3rd Test - Australia v India (Day 3) |
29/12/2018 | BBL - Melbourne Renegades v Sydney 6ers |
29/12/2018 | WBBL - Melbourne Renegades v Melbourne Stars |
29/12/2018 | Day Gallops |
29/12/2018 | Boxing Day - 3rd Test - Australia v India (Day 4) |
<tbody>
</tbody>