Random Figure Output Function

[rdpriest]

I am trying to put medicare costs for certain treatments into a function in excel. I want to set it up so that if I put the code for a treatment in one code the amount that Medicare pays for that treatment shows up in another column. Because there is no Mathematical formula for determining how much is paid (randomly picked by legislators), I don't know how to write a formula for it. Is there a way to set up a chart with corresponding values such that if I put in one value in B2, C2 always gives me the corresponding value? I saw that the logic formulas permit this on a rudimentary level, but I want to put in about 100 codes and have 100 related responses, so that I am not tirelessly looking up each value each and every time......Thanks for your help

[NBVC]

Yes, Have a look at the Vlookup function in Excel Help... it will do exactly what you want once you set up a lookup table.

[ChemistB]

You'll need to use VLOOKUP. For example, create your list on Sheet2 from A2:B100 and in C2

Please Login or Register  to view this content.

Here's more explaination on VLOOKUPs
http://www.contextures.com/xlFunctions02.html

ChemistB