The formula should of course be placed in a cell other than F5/Q5, say maybe
in G5? Q5 is just an assumption, you should change it to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Belinda7237" wrote in message
...
I am getting a circular reference error - my F5 cell in my current sheet
holds the unique invoice number that I am matching in the F cells in my
week
3 dataset and column Q in both holds the dollar value that i am looking to
update. Should I be using Q5?