I think VLOOKUP is the function you're looking for. Something like this
formula placed in cell C250, where you enter the name you're looking for into
cell B250:

=VLOOKUP($B$250,$B$37:$DT$47,COLUMN(C250)-1,FALSE)

This can then be copied across cells D250 through DT250. You'll probably
need to modify this slightly to fit your needs. Look up VLOOKUP in Excel
Help to learn more.

HTH,
Elkar


"olrustyxlsuser" wrote:

I have a data range b37:dt47 which consists of information relevant to
11 different items. For now let's call the items a:k. I would like to be
able to populate an item's row of data/formulas based on inputting the
corresponding letter of the item in a cell. If I want the information for
item "b", currently I need to copy the entire row (38) and paste it in a
different location (let's say row 250). I would like to simply type "b" in a
cell in row 250 and for the data/formulas relevant to "b" to populate across
the new location. (cells b250:dt250)
I believe I could accomplish this with "If" statements in each cell
(after a few weeks of entering formulas) but I'm sure there must be a better
way.
Additionally, I can only hope that part of this formula could be used
to populate similar data from a drop-down selection in a seperate worksheet
in the same workbook.
Any assistance would be greatly appreciated.