Pulling info from one tab to another based on conditions

I know what I want to do, but I can get much further in formula building.

I have a spreadsheet with several pages.

ENTRY page is just for data entry, and there are multiple columns. They key columns that I'm interested in are C (NAME), F (ORDER), S (NOTES)
In the C column, there are names. (obvious enough)
In the F column, there are dollar amounts.
In the S column, there are critical notes about the order.

ORDER page is another page that will list only the orders from the ENTRY page. It has two columns: A (NAME) and B (NOTES)

What I would like to do on the ORDER page is to create a formula that populates both the NAME and NOTES column from the ENTRY page.

Therefore, if I use the example below:

ENTRY PAGE

	C	F	S
Row1	Tom	$1.00	Class A
Row2	George		Query only
Row3	Sally	$4.00	Class B

The ORDER page will look like this:

A	B
Tom	Class A
Sally	Class B

How can I make this happen?

Hi,

Please take a look at my attachment. I hope this is what you were looking for

In column A on the ORDER page, I have used the array formula

Formula:

Please Login or Register  to view this content.

which needs to be entered using Ctrl + Shift + Enter as opposed to just Enter. In column B, the formula is very similar, but refers to column S instead of column C in the index parameter:

Formula:

Please Login or Register  to view this content.

You can then drag these formulae down each column as far as is necessary.

Hope this works for you

The first one is working. However I can't drag the formula down - it keeps repeating the same reference.

The second one was working, but I had to change the column reference from S to T, and now I can't get it to work.

This is amazing though. I was way off base. I really need to learn a lot more about Excel.

Hi,

The only reason it would be repeating the same reference when you drag down is if you have used an absolute range reference in the ROWS formula (right at the end of the entire formula). It should be

Formula:

Please Login or Register  to view this content.

but will return the same reference all the way down if you have accidentally used

Formula:

Please Login or Register  to view this content.

To change the column from S to T, all you need to change is the reference in the INDEX's array argument, so it becomes

Formula:

Please Login or Register  to view this content.

The arguments in the ROW/ROWS functions are simply placeholders, so it doesn't matter what column they are referring to, all that matters is that they are counting how many rows are in your table.

Just worth mentioning again, both of these formulae are array formulae, so they need to be entered using Ctrl + Shift + Enter. It just occurred to me that this may be the reason if you couldn't get the second formula to work after you changed it.

Hope this helps