Can someone tell me how I would do the following:

- I have numbers in cells E5:E10; A1 and B1
- I would like to search for A1 in cells E5:E10
- On the first instance I find of A1, I would like to replace the
value of that cell with B1

What would be a simple way to write this?

Thanks,
Fish