Link

[Iryna]

Hi,
Please help...
I have data in columns A, B, C,

6.75 0.01 0.1255
7.00 0.002 0.0386

I need to link "0.1255" Column "C" to "6.75" "A" then take
"6.75" to another sheet.

Thanks Iryn

 

[Frank Kabel]

Hi
not quite sure but maybe something like
=INDEX('sheet1'!$A$1:$A$100,MATCH(0.1255,'sheet1'!$C$1:$C$100,0))

 

[Andy B]

Hi

I'm guessing a bit here.
Try this:
=INDEX(A1:A50,MATCH(0.1255,C1:C50))
Change the ranges to suit. This needs to go into the cell on the 'other
sheet'.
If I've not understood, try again!!

Andy.

 

[Iryna]

Thanks for help,
But it didn't work.

Iryna. :confused

 

[Frank Kabel]

Hi
you may provide some more details
Otherwise the only thing we can do is guessing.
- So provide some example rows of your data (plain text - no
attachments please)
- describe your expected result
- etc

 

[Andy B]

Hi

It may help us if you give a bit more information of what you want

Andy.

 

[Iryna]

I have data in columns A, B, C,
6.50 0 1E-04
6.75 0.1255 0.001
7.00 0.0386 0.0043
7.25 0.0348 0.0214
7.50 0.0439 0.4556
7.75 0.0278 0.0917
8.00 0.0529 0.1434
8.25 0.0517 0.1007
8.50 0.0709 0.1056
8.75 0.1464 0.1667
9.00 0.1228 0.1146
9.25 0.2136 0.1705
I need (If 0.1255 is bold) find cell in "A" which corresponding t
bold numbers and take this cell to the second sheet.

Thanks Iryn

 

[Frank Kabel]

Hi
no chance using formats for this (at least not without VBA)

What is possible matching numbers. Say you enter 0.1255 in cell G1
enter the following in H1
=INDEX(A1:A100,MATCH(G1,B1:B100,0))
this will return in this case 6.75 from column A

 

[Iryna]

Hi Frank,
I am not talking about formatting . I want take the cell value t
anothersheet.

thanks Iryna.:confused

 

[Frank Kabel]

Hi
o.k just adapt the formula. Lets say you have your data on sheet 1 and
you enter a value in cell A1 on sheet 2. Enter the following in cell B1
on your second sheet:
=INDEX('sheet1'!A1:A100,MATCH(A1,'sheet1'!B1:B100,0))