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?
Bookmarks