How do I find a value in a table without using the labels?

B

BobbyR

I have a table with a bunch of values. I need to find a value from the
chart. the values are numbers based on different areas of steel. The values
are the list by column one having one times the area to column 18 having 18
times the area. The problem comes because if the areas are listed for the
first column:
0.11
0.20
0.31
0.44
0.60
0.79
1.00
1.27
1.56
2.25
4.00

Then multiply out and you will see. I want the value that is just larger
then the value I get from an equation from the table. So when you see the
rows, you will notice that just because the answer is in a higher coulmn
doesn't always fix what I am looking for. Could someone help?
 
D

Dennis Tucker

I would help you if I understood the problem better.

You lost me at "...The problem comes because if ..."

Can you send me a copy of the workbook and explain the issue a little
better?

I'm willing to help.

Dennis
 

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

Calculate the median value before a specified list 0
Value of the first day of a year in a list 5
Unable to set the desired column width for a table with merged cells 0
How do I set up a formula to give me an average based on IF? 1
Unable to set the desired column width for a table with merged cells 0
How Do I Find Different Values In A String? 2
Using VBA to find a value and select a range 4
Automatic sequential numbering where a value changes 4

Top