Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |