I have a rather unusual problem I hope you can help me with. I am writing an excel calculation sheet that needs to refer to a table. The reference from the table is not in the coventional sense. Instead of knowing the first column values and the first row values, I know the first column values and the value located in the row of the known 1st column value. I need to then get the first row value located in the column of the table value. VLOOKUP, and HLOOKUP don't help me. Is there a formula or an excel function that can help me??
Tables
-
-
Is it possible to post a little of your data so that we can getter a better understanding of what you are actually trying to do!!
-
Quote
Originally posted by RadMan
I attached the table. let's say I know the dose/fraction is 250, and I know the table value is 56. I need excel to look up 12 for the number of fractions.DID NOT UNDERSTAND WHAT YOU ARE TRYING TO SAY , EXPLAN PLS.
-
Here is one way to answer your question. Although it may not be exactly what you want it is very close. All the credit for this one goes to Aladin Akyurek.:D
-
I agree for above example , it should work.
Thanks to PJ KARAFFA
Regards
S.Suresh -
RadMan,
It took some time but I think this is the answer that you are looking for Compliments of Aladin Akyurek!!
