Find data from one sheet in another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cstraim@yahoo.com - 21 Aug 2006 17:26 GMT

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

Reply to this Message

Dav - 21 Aug 2006 17:41 GMT

cstraim@yahoo.com Wrote:

> Hello
>
[quoted text clipped - 16 lines]
>
> Cory

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

Regards
Da

Reply to this Message

cstraim@yahoo.com - 21 Aug 2006 17:41 GMT

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 :)

> Hello
>
[quoted text clipped - 15 lines]
>
> Cory

Reply to this Message

Dav - 21 Aug 2006 19:08 GMT

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

Regards

Da

Reply to this Message