Adding another IF statement

[andy2707]

Hi there,

If I am duplicating a post, I am sorry, there are so many on here and I do not know what words to search with

I am simply using a VLookup, but am stuck

=IF('datasheet'!$L2=1,VLOOKUP($A5,'datasheet'!$A$2:$T$500,14,0),0)

The reason for the IF, is that there are two data sets I want to refer to based on L2.

Where I need help is that I need to edit the above formula so that the output also looks at the month of each row which is 'datasheet'!D2:D500

Hope this make sense???

[PaulM100]

The vlookup should look at the month or the if? also, would be helpful to upload a sample. To upload - Go Advanced - Manage Attachments -

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[andy2707]

I have uploaded a sample. In cleaning the sensitive data, it has given a #Ref on the summary sheet, but hopefully you will at least understand what I am asking ??

[PaulM100]

You still haven't told us what you are trying to achieve and where the month criteria should go

[andy2707]

Referring to the summary sheet, I want to make 3 tables, one per month.

The current formula just reads every row of the data sheet, I would like each table (per month) to filter the results based on the chosen month.. does that make sense?

so hotel 1 and cell b5, I would like the return value to just show bookings for hotel 1 in june, then cell R5 will be the just for July....

So i try to ask how should the formula be written? perhaps the combination of the IF and VLookup is not the best, I just don't know

[andy2707]

I apologize, I have realized I can use SUMPRODUCT instead of the original formula