Excel: How to dynamically change text within a formula using text from a reference cell

I have the following line I am working on:

=VLOOKUP(B16,PI_Rank_Ferox,2,FALSE)

I am trying to take text in the formula (the example shows the word Ferox) and make it dynamically changed based on what's happening in another cell (the text in the cell H3).

So if H3 shows the word Griffin, I want the cell to change to this:

=VLOOKUP(B16,PI_Rank_Griffin,2,FALSE)

If H3 shows the words Slasher II, I want it to look like this:

=VLOOKUP(B16,PI_Rank_Slasher_II,2,FALSE)

Any advice?


A use for the INDIRECT function.

Try:

=VLOOKUP(B16,INDIRECT("PI_Rank_" & H3),2,FALSE)

Note that INDIRECT is a volatile function, and if you have a large number of formulas using this, it may slow down your worksheet calculations