I'm working with a report for my ARMY unit and I need a formula that will fill out one cell depending on the info. on the previous cell, for example if i write "SGT" in cell B1 I want cell C1 to show "E5".
It work out great but I'm affraid I need a little more help, I'm working on this report that includes different ranks, from PV2 all the way to Maj., and in cell B4 - B173 I'll be writing the rank and in cells C4 - C173 the grades,
and so on.
There are a couple different ways you could do that. The easiest would probably be a VLOOKUP formula. It will look for the value in the first column of the table and return the value from a column to the right.
In this example: If B1 is blank, display nothing, otherwise find the value of B1 in the left-most column of the table B4:C175 and return the value from the 2nd column of the table (in this case, column C).