Hello,
I am going to try and describe my issue in as much detail as possible, I hope someone out here can be of assistance.
I have a spread sheet that has a small table that contains two columns. The first is the name of a company, the second being their respective growth in sales this year/ last year. They are in no particular order.
Anyways, that data has to be transplanted to a larger table, which contains the company name, that financial metic as well as a host of others.
I am to rank them in this large chart based off of the year sales/sales metric. I started by using LARGEST function to rank the data on the big table. I managed that successfully.
I am now trying to use VLookup to populate the company name part, based on the sorted data from the LARGEST function.
I keep returning errors.
My Formula in cell B5 looks as such =VLOOKUP(D5, H35:J62, 2)
D5 being the first cell in the big table for the sales/sales metric, that already contains the LARGEST function.
H35:J62 is the smaller table where the names and values for the larger table are located
2, is the column that contains the actual numeric data in the smaller table. The smaller table is laid out "Company Name X", "X company's Sales/Sales Value"
I did not use the TRUE/FALSE argument as leaving it blank=writing TRUE, but I have also tried false.
I keep getting "N/A" as a result.
Again, I am trying to display the name of the company that is tied to a specific metric in the lower table. If VLOOKUP is not what I need to be using then please, let me know.
Thanks for the help.
Bookmarks