Just to ask, is it possible to utilise this formula for only one entry e.g.

If cell B19 is left blank, then cell B20 is populate with a "Please select
an option" response?

Thanks.

"John C" wrote:

You need a VLOOKUP:
C1: =IF(COUNTIF(Sheet2!$A$1:$A$100,A1)=0,"no
match",VLOOKUP(A1,Sheet2!$A$1:$C$100,3,FALSE))

It checks to see if the A1 has a match on Sheet2!$A$1:$A$100. If no match,
it returns "no match" (change to suit your needs). If there is a matchup, it
pulls the respective value in column C on sheet2.

Hope this helps.
--
John C


"Tim Hill" wrote:

I'm trying to setup a worksheet so that it directly refers to another but am
having problems doing so.

Basically to summise what i want to happen, if a1 (sheet 1) is equal to a1
(sheet 2) then c1 on sheet 1 will change to c1 on sheet 2 - if a1 (sheet 1)
is equal to a2 (sheet 2) then c1 on sheet 1 will change to c2 on sheet 2 and
so on and so forth...

Can anyone shed some light on this for me?