Hello

I am trying to find or match a value from one sheet in another sheet.
So for example

The formula would look at the value in cell A1 Sheet 1 and look for the
value in $A$1:$A$50 Sheet 2. If it finds it, then it would return a
value of true, OR it would return the value in cell C1 from Sheet 1.

The problem I have been facing is that if I were to use the Vlookup
function, I would not be able to retun the value of c1 from sheet one,
it only returns the value where the table array is (which in this case
is Sheet 2!!)

Anybody have any ideas on how I can do this?

Thanks

Cory

Wrote:
Hello

I am trying to find or match a value from one sheet in another sheet.
So for example

The formula would look at the value in cell A1 Sheet 1 and look for
the
value in $A$1:$A$50 Sheet 2. If it finds it, then it would return a
value of true, OR it would return the value in cell C1 from Sheet 1.

The problem I have been facing is that if I were to use the Vlookup
function, I would not be able to retun the value of c1 from sheet one,
it only returns the value where the table array is (which in this case
is Sheet 2!!)

Anybody have any ideas on how I can do this?

Thanks

Cory

if(iserror(match(a1,sheet2!$a$1:$a$50,0)),c1,"True ")

Regards
Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=573830

Ok Let me try to make it a bit more clear. Here is how it is setup
Sheet 1
A B
1 Ten 30
2 Ten 40
3 Ten 50

Sheet 2
A
1 Ten
2 Twenty
3 Thirty

What I'd like to do is check to see if the value of A1(sheet 1) exists
in Sheet2(A1:A3). If it does then return the value in Sheet1B1. In
this case it would be 30. Again i tried this with V lookup but it
bombs out once I try to get the value from Sheet1B1. Probably becuase
the array i'm using to look up the data from is on Sheet2 not Sheet1.

Thanks for your help :)
wrote:
Hello

I am trying to find or match a value from one sheet in another sheet.
So for example

The formula would look at the value in cell A1 Sheet 1 and look for the
value in $A$1:$A$50 Sheet 2. If it finds it, then it would return a
value of true, OR it would return the value in cell C1 from Sheet 1.

The problem I have been facing is that if I were to use the Vlookup
function, I would not be able to retun the value of c1 from sheet one,
it only returns the value where the table array is (which in this case
is Sheet 2!!)

Anybody have any ideas on how I can do this?

Thanks

Cory

if(iserror(match(a1,sheet2!$a$1:$a$3,0))"",b1)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=573830