Sounds like you're after something like this:
=IF(INDEX('Week 3 projected dataset'!Q:Q,MATCH(F5,'Week 3 projected
dataset'!F:F,0))=Q5,Q5,INDEX('Week 3 projected dataset'!Q:Q,MATCH(F5,'Week 3
projected dataset'!F:F,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Belinda7237" wrote:
I am comparing two sheets of data utilizing a common identifier in my master
sheet column F is my identifier fand column Q is my dollar value:
If my dollar value in Column Q in my second sheet (week 3 projected data
set) is different then the value found in my laster, then I want to update
it, if the value is the same i want to do nothing.

I dont have it quite right:


=if(F5,'Week 3 projected dataset'!F:F,'Week 3 projected dataset'!Q2,0)