If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
Does any one know how to get a value from one worksheet
to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would be used to look up a number on the first sheet (like x,y coordinates). The first number would correspond to a value in a row of the first sheet. the second number would correspond to a value in a column of the first sheet. The value in the cell that shares both row and column in the first sheet with these 2 values would be the value I want to put in the third column of the second sheet. |
#2
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
Hi
try something like =INDEX('sheet1'!$A$1:$F$100,MATCH(A1,'sheet1'!$A$1 :$A$100,0),MATCH(B1,' sheet1'!$A$1:$F$1,0)) -- Regards Frank Kabel Frankfurt, Germany wrote: Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would be used to look up a number on the first sheet (like x,y coordinates). The first number would correspond to a value in a row of the first sheet. the second number would correspond to a value in a column of the first sheet. The value in the cell that shares both row and column in the first sheet with these 2 values would be the value I want to put in the third column of the second sheet. |
#3
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
Thanks for the feed back. Didn't work for me. I also
tried substituting columns ( a,b,c...) where my values are for letters in the formula. I don't understand the syntax of the command below so I may not have changed things properly. On sheet one column B is the first set of numbers that need to be matched with column A on the second sheet. On the first sheet row 1 columns C - AD are the values that need to be matched to the numbers in column B on the second sheet. Columns C - AD Rows 2 and downward have data that I need to automatically get to column C on Sheet 2. -----Original Message----- Hi try something like =INDEX('sheet1'!$A$1:$F$100,MATCH(A1,'sheet1'! $A$1:$A$100,0),MATCH(B1,' sheet1'!$A$1:$F$1,0)) -- Regards Frank Kabel Frankfurt, Germany wrote: Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would be used to look up a number on the first sheet (like x,y coordinates). The first number would correspond to a value in a row of the first sheet. the second number would correspond to a value in a column of the first sheet. The value in the cell that shares both row and column in the first sheet with these 2 values would be the value I want to put in the third column of the second sheet. . |
#5
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
Changed formula.
=INDEX(Sheet1!$B$1:$AD$100,MATCH(A1,Sheet1! $A$1:$A$100,0),MATCH(B1,Sheet1!$A$1:$F$1,0)) -----Original Message----- Hi post your changed formula :-) -- Regards Frank Kabel Frankfurt, Germany wrote: Thanks for the feed back. Didn't work for me. I also tried substituting columns ( a,b,c...) where my values are for letters in the formula. I don't understand the syntax of the command below so I may not have changed things properly. On sheet one column B is the first set of numbers that need to be matched with column A on the second sheet. On the first sheet row 1 columns C - AD are the values that need to be matched to the numbers in column B on the second sheet. Columns C - AD Rows 2 and downward have data that I need to automatically get to column C on Sheet 2. -----Original Message----- Hi try something like =INDEX('sheet1'!$A$1:$F$100,MATCH(A1,'sheet1'! $A$1:$A$100,0),MATCH(B1,' sheet1'!$A$1:$F$1,0)) -- Regards Frank Kabel Frankfurt, Germany wrote: Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would be used to look up a number on the first sheet (like x,y coordinates). The first number would correspond to a value in a row of the first sheet. the second number would correspond to a value in a column of the first sheet. The value in the cell that shares both row and column in the first sheet with these 2 values would be the value I want to put in the third column of the second sheet. . . |
#6
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
I changed the formula again without good result.
=INDEX(Sheet1!$B$2:$AD$100,MATCH(A2,Sheet1! $B$2:$B$100,0),MATCH(B2,Sheet1!$C$2:$AD$2,0)) |
#7
|
|||
|
|||
look up a value in another sheet bases on vaues ound in another cell
WHOooHOO!!
Got it. Thanks for your help. =INDEX(Sheet1!$B$1:$AD$100,MATCH(A2,Sheet1! $B$1:$B$25,0),MATCH(B2,Sheet1!$C$1:$AD$1,0)) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
the sum from one cell on a sheet1 minus a cell on sheet 2 | qwerty | Worksheet Functions | 1 | June 3rd, 2004 09:29 PM |
Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet | Minitman | Worksheet Functions | 1 | February 25th, 2004 05:26 AM |
Sort by name - populate cell on diff sheet with that name | mrsimps | Worksheet Functions | 1 | December 20th, 2003 02:29 AM |
Sheet name in a cell | Joann L. | Worksheet Functions | 3 | November 21st, 2003 06:40 PM |