Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
|
|||
|
|||
Quote:
Denise |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine Combo Box function with Vlookup function | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |