Need Help soon on how to search through a range
 

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

Need Help soon on how to search through a range
 

Is another way to say what you want:

For any row in Sheet 2, if the cell in column B matches Sheet 1,cell D1, and
the cell in Column C matches the same cell in Sheet 1 then the cell in
column G should say "Whatever?"

If so then try pasting this formula into Sheet 2, G1 and copy down:

=IF(AND(B1=Sheet1!$D$1,C1=Sheet1!C1),"whatever","" )

hth,

Doug


"VBAapprentice"
wrote in message
news:VBAapprentice.24ovrm_1142389501.2228@excelfor um-nospam.com...

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