Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in if..
I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO
HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in if..
look at VLOOKUP, or MATCH and INDEX in help.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CINDY" wrote in message ... I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in if..
I HAVE TRIED ALL THIS I JUST CANT FIGURE THE RIGHT FORMULA
"Bob Phillips" wrote: look at VLOOKUP, or MATCH and INDEX in help. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CINDY" wrote in message ... I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in if..
hi Cindy,
Try using VLOOKUP as below =VLOOKUP(A1,Master_Info!A1:D12,2,FALSE) I am assuming : 1. Your data is in the range of A1 till D12. 2. You want to lookup A1 of the Monthly Orders sheet with Master Info. 3. You want to get the data at the 2nd column from the leftmost of your data. Try using VLOOKUP this way and you will get the desired output. Hope this works for you. thanks, Shail CINDY wrote: I HAVE TRIED ALL THIS I JUST CANT FIGURE THE RIGHT FORMULA "Bob Phillips" wrote: look at VLOOKUP, or MATCH and INDEX in help. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CINDY" wrote in message ... I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill option | New Users to Excel | |||
Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
Fill handle formula | Excel Worksheet Functions | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) |