I am new to VBA programming in excel outside of UserForms. I am trying
to handle the following situation and I am not sure if there is away to
do it via excel worksheet function or if I need to write a VBA block to
do it. If I do it VBA Code I am not sure how to fil the rest of column
with the function

here is the situation:
If worksheet(1).Range(D1) is in worksheet(2).Range(b:b) then i want to
check column C of that row where (d1) is located on worksheet(1) to see
if is equal to worksheet(1).range(c1)
and if it is I want to set G1 = "whatever"

does anyone have any suggestions?


--
VBAapprentice
------------------------------------------------------------------------
VBAapprentice's Profile: http://www.excelforum.com/member.php...o&userid=32465
View this thread: http://www.excelforum.com/showthread...hreadid=522487