If with multiple worksheets
 

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?

If with multiple worksheets
 

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?

If with multiple worksheets
 

fantastic, thanks alot for your help john

Much Appreciated

Tim

"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?

If with multiple worksheets
 

You're welcome, and thanks for the feedback. :)
--
John C


"Tim Hill" wrote:

fantastic, thanks alot for your help john

Much Appreciated

Tim

"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?

If with multiple worksheets
 

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?

If with multiple worksheets
 

B20: =IF(B19="","Please select an option",VLOOKUP(B19,yourtable,column,false))

Is that what you were wondering? If not, provide more detail.
--
John C


"GillianX" wrote:

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?