Board index » Excel » Help with code please?

Excel25
I am looking for an easier way to do this? I want to have column "f" lookup

cell "a1" on sheet 2 and if it matches say yes or if it doesnt to remain

blank.



How do I do this?



Thanks



Greg


-

if i understand correctly you'll need a 2nd column,



=if($f1=Sheet2!$A$1,"Yes","")



if you want to match what is in column F to Sheet2 A1



if you want to have Column F say Yes or be blank, using this formula will

create a circular reference.



J



"Greg B" wrote:

"Greg B" <laptopgb@ihug.com.au>wrote in message

What do you want to compare to the value in a1? You want column f to return

yes or no, does an adjacent column contain values you want to compare?





-

How are you doing it now?



--

Don Guillett

SalesAid Software

donaldb@281.com

"Greg B" <laptopgb@ihug.com.au>wrote in message



-

Sorry I never explained it very clear at all.



I am using the if function which works well,



=if(a2=sheet1!a3,"yes","")



but when i copy and paste it becomes



=if(a3=sheet1!a4,"yes","")



How do I get the Sheet1 value to stay static?



Hope that it easier to understand.



Thanks



Greg







-

try



=if(a3=sheet1!$a$4,"yes","")

-

sorry it meant



if(a3=sheet1!$a$3,"yes","")

-

Thanks for that



Greg

"Ashley Milford via OfficeKB.com" <forum@OfficeKB.com>wrote in message



-