look up a value in another sheet bases on vaues ound in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
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.
 
Changed formula.
=INDEX(Sheet1!$B$1:$AD$100,MATCH(A1,Sheet1!
$A$1:$A$100,0),MATCH(B1,Sheet1!$A$1:$F$1,0))
 
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))
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Dependent drop down dynamic range formula, off sheet. 7
Formula Based on Multiple Sheets 5
Count the columns from one sheet and paste it in another sheet 0
use month in cell date to sum all relevant cells 2
Match and delete rows on two different sheets from reference numbers 4
Vlookup and return sheet name also 2
Creating a dynamic IF statement 2

Back
Top