I have two tabs on my spreadsheet “green” and “blue”. Muchof the content is identical but has been sorted for numerous reasons.
The blue tab is where my destination cells are and where theformula should go. I need a formula for P2 that looks at D2 and compares it toD2 – D120 on the green tab. If it finds the value in D2 anywhere on the greentab D2 – D120, report the value from P2 green tab in P2 blue tab. I’ll dragthis formula down so it does the same thing P2 – P120.
I hope this makes sense and isn’t too confusing.
Thank you in advance.
The blue tab is where my destination cells are and where theformula should go. I need a formula for P2 that looks at D2 and compares it toD2 – D120 on the green tab. If it finds the value in D2 anywhere on the greentab D2 – D120, report the value from P2 green tab in P2 blue tab. I’ll dragthis formula down so it does the same thing P2 – P120.
I hope this makes sense and isn’t too confusing.
Thank you in advance.
