thanks for reply, but i was looking for something to look at master
file, and if value matches consistently update rather than me manually
updating. if i use = to the file, that means i am telling it what to
pull through rather than using the IF function.
Does that make more sense?

----------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=509021