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:

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

"Greg B" wrote in message
...
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?

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

"Greg B" wrote in message
...
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

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" wrote in message
...
sorry it meant

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