More help w/ Match or Lookup

[Guest]

I am trying to build a worksheet which will search on data from sheet 1 from
a column in sheet 2, and place the text result of an unknown intersection of
sheet 2 back into sheet 1
sheet 1:
Line 125 (g3)
Name "result"
sheet 2:
column J (contains line #)
columb D (contains name)

I'm trying to look for the line #, find the name in that row, and place the
name into the cell on sheet 1.

 

[Niek Otten]

=INDEX(Sheet2!D1100,MATCH(G3,Sheet2!J1:J100,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to build a worksheet which will search on data from sheet 1 from
| a column in sheet 2, and place the text result of an unknown intersection of
| sheet 2 back into sheet 1
| sheet 1:
| Line 125 (g3)
| Name "result"
| sheet 2:
| column J (contains line #)
| columb D (contains name)
|
| I'm trying to look for the line #, find the name in that row, and place the
| name into the cell on sheet 1.
|
|

 

[Guest]

I must be doing something wrong, I keep getting a dialog box opening "Update
Values: telephone" (which is the name of Sheet 2) Any ideas?

 

[Niek Otten]

In my formula, replace Sheet2 with 'Update Values: telephone'
DO include the apostrophes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I must be doing something wrong, I keep getting a dialog box opening "Update
| Values: telephone" (which is the name of Sheet 2) Any ideas?
|
| "Niek Otten" wrote:
|
| > =INDEX(Sheet2!D1100,MATCH(G3,Sheet2!J1:J100,0))
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I am trying to build a worksheet which will search on data from sheet 1 from
| > | a column in sheet 2, and place the text result of an unknown intersection of
| > | sheet 2 back into sheet 1
| > | sheet 1:
| > | Line 125 (g3)
| > | Name "result"
| > | sheet 2:
| > | column J (contains line #)
| > | columb D (contains name)
| > |
| > | I'm trying to look for the line #, find the name in that row, and place the
| > | name into the cell on sheet 1.
| > |
| > |
| >
| >
| >

 

[Guest]

It would probably help if I could type! Thanks for your help - it works!!!