Find data from one sheet in another sheet
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 |
Find data from one sheet in another sheet
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 |
Find data from one sheet in another sheet
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 |
All times are GMT +1. The time now is 05:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com