Link

  • Thread starter Thread starter Iryna
  • Start date Start date
I

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
 
Hi
not quite sure but maybe something like
=INDEX('sheet1'!$A$1:$A$100,MATCH(0.1255,'sheet1'!$C$1:$C$100,0))
 
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.
 
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
 
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
 
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
 
Hi Frank,
I am not talking about formatting . I want take the cell value t
anothersheet.

thanks Iryna.:confused
 
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))
 
Back
Top