If or VLookup function
I am trying to do something with a workbook and hope you can help me. Not sure if I'm supposed to use an IF function or VLOOKUP or even a combination of both. Here's what I want to do:
I have 2 sheets in this workbook. Sheet 1 has dates going down a column. Sheet 1 also has a row with names on it across the top row. Sheet 2 also has dates going down a column but don't match the ones in sheet 1. Ideally, I'd like to put an "X" in the column for availability and use the dates on sheet 1 as a range (or not exact if that's easier to understand). For example, I have a part that is available on Sheet 2 for November 15th. Sheet 2 has parts that will be available on August 1, November 10, and December 2, and January 2. I want the "X" to be shown in a row across from December 2 because the November 15 date falls within that range and January 2. It wouldn't fall within November 10 because the part isn't available until November 15th. Is this possible? Thanks, Denise |
Quote:
Your explanation is a little confused. Please, to easier the help, is it possible you put your worksheet here in attachment? Put there an example with waited results. I´m sure that you will receive help faster and much more effective. Thanks. |
Quote:
Denise |
2 Attachment(s)
Here is sheet 1 (I want the "X's" to go down the column where the names are and match up with the dates on the left in the rows).
I'm also attaching sheet 2 where the information would be retrieved from. |
1 Attachment(s)
Quote:
I built an example of worksheet for you using your data. It´s attached. BUT, I didn't found any records that match your criteria. I think. Please, fill at least one example on it. Do it manually. I´m here waiting you answer. We will solve this question. |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com