Re: MATCH a cell to a Range of a periodically updated list of records
Quote from pangolin;739828
put this formula in 1st row and copy down
Hi pangolin, and thankyou very much for your response. I can't get the function to update if I paste another 20 rows of data after the last 20 in sheet2. I've made up a simple worksheet for you to look at. I'm sure it's a minor issue.
Just imagine that a vba formula pastes a fresh set of 20 values to sheet2 each time a new race appears on the sheet1, and then 30 secs later the continually updating values on sheet1 freeze, a comparison is made with the last 20 values in the sheet2 column and the instruction "Lay" is fired if there's a match.