Hi All,
First post here, so 'Hello to all'. I'm using the Match function to match names against another sheet, which has imported data on it from the interweb. The position of the data will vary.
=MATCH("*"&C8&"*",'Import League'!$B$83:$B$106,0)
So C8 is the team name to be matched against sheet Import League, between B83 and B106. As mentioned, the team positions may change, so next week it may be B87 to B110 etc...
I therefore need to change B$83:B$106 to refer to 2 fixed cells on the current sheet, where I've identified the start and end positions using another Match function.
How can I do this please?
Many thanks
Bookmarks