About Us

ruthhicks999

I have a table of data (on a sheet called catalogue data) which contains a ranking of order of sales in the previous month. I have then used an if statement =IF(G2=1,"Best Seller", IF(G2=7,"Worst Seller", " ")) to return Best Seller or Worst Seller depending on the ranking.

On another sheet Sales Statistics I want to put the description of the best Seller based on a lookup on the original table is this possible? I have tried I have tried =VLOOKUP("Best Seller",'Catalogue Data'!B2:H8,2,FALSE) but get #N/A as the result.

I have attched screenshots of the two sheets to help you sort out what I mean. In this case I am expecting the result of PS3

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to return multiple results in vlookup?	Landa	Excel Worksheet Functions	3	July 20th 06 08:27 AM
IF statement colored results	matles007	Excel Worksheet Functions	1	May 18th 06 02:29 PM
if/then statement that results in Yes/No	Patty via OfficeKB.com	Excel Discussion (Misc queries)	3	August 3rd 05 02:26 PM
Vlookup of an if statement return	James	Excel Worksheet Functions	2	April 6th 05 10:28 PM
adding if statement results	Robb27	Excel Worksheet Functions	3	November 20th 04 05:27 AM

Menu

About Us