Displaying data from two cells in another based on criteria

**BridgeCat** · 04-25-2011, 09:11 PM

Hi,

I have a spreadsheet full of sales and cost data for a store. What I would like to do is pull the name and the sales figure for of any item in under a particular value and display it in another table.

For example

IF anything in Column F is less that 50% then the item name Column C will be displayed in I6, and the Sales figure will be displayed in J6.

I have attached a spreadsheet for example. I update the data in the worksheet monthly, so sales figures continually change, and items are added.

Thanks for your help!
BridgeCat

**Alf** · 04-26-2011, 03:29 AM

Perhaps like this?

Alf

**BridgeCat** · 04-26-2011, 08:43 AM

Thats perfect thanks! Is there any way to have the list sort in ascending order based on sales values in Column F?

**Alf** · 04-26-2011, 10:49 AM

I assume it's list in column J you wish to sort in ascending order?

If this clears up your problem could you please mark your tread "Solved" and if you like to give me a pat on the back click on my scale icon and give a rating to my answer.

Alf