How do we find a value within a large range of cells (eg. Find "0001ABC" within A1:Z1000) and return the value of the cell right next to that value (eg. if you manage to find "0001ABC" which could be anywhere within A1:Z1000, give the value of the cell right next to it)?
Many thanks!
Bookmarks