Urgent help with a formula

F

Frances Reese

If I have column labels at the top of my work sheet and
have a list of items, how do I write a formula that will
give me the result of the name of the column label the
item is found in?
Column Labels: Fruits Nuts Candy Unknown
Almond Skittles Apple
Item Category
Skittles return "Candy"
Apple return "Unknown:
Almond Find "Almond" in B2:E10, then return the Column
Label (Nuts) where "Almond" is located.
 
P

peter

Hi,
I don't know any way in excel to find an item within a
matrix(row/col).
Re-think your design. Put your data in two
columns,item...category. Then use vlookup to return the
category of the selected item. At the risk of entering
the data twice, once in the columns and once in the
matrix, you could write a macro that would populate the
matrix with the data from the columns.

peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
rewording of formula request 6
formula to count text entries and return text with most entries 12
how to re-group the cells from vertical to horizontal 1
On Entering Data in On Cell Enter a Formula in Another 0
Need help with IF Formula 4
Splitting data from one spreadsheet into multiple spreadsheets 2
help with a vlookup 2

Top