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.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJW" wrote in message ...
|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.
|
|

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!D1:D100,MATCH(G3,Sheet2!J1:J100,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJW" wrote in message ...
|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.
|
|

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJW" wrote in message ...
|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!D1:D100,MATCH(G3,Sheet2!J1:J100,0))
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "SJW" wrote in message ...
| |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.
| |
| |
|
|
|

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

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SJW" wrote in message ...
|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!D1:D100,MATCH(G3,Sheet2!J1:J100,0))
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "SJW" wrote in message ...
| |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.
| |
| |
|
|
|