SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,104
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi All
I have a sheet called MAIN PAGE. I am trying to write a formula in cell C5.
I want to look on a sheet called 1ST in column A:A(has dates) and find a match for MAIN PAGE G2(has a date), once it finds the match I want to display the contents of 1ST column D from the same row in MAIN PAGE C5.
I have similar formula that work but now dates seem to be involved I cannot get it to work.
all help and pointers gratefully received.
Dave
I have a sheet called MAIN PAGE. I am trying to write a formula in cell C5.
I want to look on a sheet called 1ST in column A:A(has dates) and find a match for MAIN PAGE G2(has a date), once it finds the match I want to display the contents of 1ST column D from the same row in MAIN PAGE C5.
I have similar formula that work but now dates seem to be involved I cannot get it to work.
all help and pointers gratefully received.
Dave