Hi, Ill try to be short.
I need a formula to check if the value of Cell S3 is found in B24:33 and if it is, I want my formula to return the value of Cell E34.
Now when I drag this formula down (Extend it) I want it to Next check B35:B44 for the value of cell S4 and if it is, return the value of Cell E45
And so on and so on. so basicall, the range is 10 rows then skips 1 row Which is the value I want returned but the valuecheck needs to move only once.
Hopefully that makes sense, if not let me know and ill try to build a testfile. EDIT: created a testfile.
Thank you in advance!
Bookmarks