I have a spreadsheet where there are 10 headers with 50 different row items. Lets just say the headers are the names of banks and the rows are the ticker symbols for stocks. When I get a price from a specific bank I put the price in the matching cell. What I am comparing is a price I originally have from my own portfolio.
If a price matches my price from the spreadsheet, it returns the text name of the bank, if it doesn't match then it puts "average". I would use nested ifs except it limits 7 and I have 10 banks.
I'll try my best to show an example with 3 securities
AA BB CC DD EE FF GG HH II JJ My prices
A 3 4 3.5 3
B 2 1 1.6 2
C 5 5.5 6 5.5
What I would like to do then is to compare each price to my prices, if that price matches it takes the bank name from the header row and puts that in a cell. Any info is helpful. I'm doing this for a list alot bigger than I've shown.
If a price matches my price from the spreadsheet, it returns the text name of the bank, if it doesn't match then it puts "average". I would use nested ifs except it limits 7 and I have 10 banks.
I'll try my best to show an example with 3 securities
AA BB CC DD EE FF GG HH II JJ My prices
A 3 4 3.5 3
B 2 1 1.6 2
C 5 5.5 6 5.5
What I would like to do then is to compare each price to my prices, if that price matches it takes the bank name from the header row and puts that in a cell. Any info is helpful. I'm doing this for a list alot bigger than I've shown.
