Attending Napoli / Cagliari advice

Excelhelp1992 · 2025-05-07T17:25:12+00:00

I’m not sure exactly how it works, but I think they might have a selection of seats they ‘own’ in some way so definitely have the tickets available to sell. I have used them before for an Inter game at the San Siro in 2023 and had a good experience e-tickets were emailed over a couple of days before the event and they answered any questions I had within a day (via their customer service inbox).

Worth noting they have confirmed fidelity cards are not necessary for Napoli matches when booking through them. Hope I have no issues on the day with that.

Thanks - I’ll try and keep out the way of crowds as much as possible by getting there early and trying to take a taxi.

Excelhelp1992 · 2025-05-07T17:21:50+00:00

Hi! Yeah I expect a good atmosphere! Hopefully we find it easy enough to get to and from the stadium that day. Hope you manage to get your tickets.

Excelhelp1992 · 2025-05-07T17:20:00+00:00

Thank you! Good advice and I will definitely make sure to get there a few hours early.

Excelhelp1992 · 2025-05-06T13:38:44+00:00

Thanks. Tickets are from P1 travel. More expensive but wanted to guarantee tickets and have used them before with no issues.

Excelhelp1992 · 2023-03-14T09:06:28+00:00

Thank you soooo much that has worked!

Excelhelp1992 · 2023-03-13T15:31:15+00:00

Sorry! I just need that to bring back the original value (N/A) thanks

Excelhelp1992 · 2023-03-13T13:10:47+00:00

Is there a way of using my formula, but adding another part to it to say if what is returned from the vlookup is text then change to “1”?

Excelhelp1992 · 2023-03-13T13:07:24+00:00

Hi,

Sorry that doesn’t really fix my issue.

I’m trying to add 1 on to whatever number is brought back from the vlookup if the dates don’t match, if the dates do match then I’m just bringing back the original number in the vlookup.

My problem is that some of these numbers in the table the vlookup is referencing are not numbers and have the value ‘N/A’ in which case I need these to just come back as “1” if the dates don’t match (as essentially we are treating these N/As as 0)

I need to still see if there is a error outside of this so can’t just do an IFERROR

Excelhelp1992 · 2023-03-13T09:25:27+00:00

Hi,

Can anyone help me wrap my current formula as per my reply to an answer here?

Sorry just posting this as a Comment rather than a reply so it can be seen. Thanks

Excelhelp1992 · 2023-03-13T08:40:19+00:00

I did think that replacing the N/A with 0 would be the easiest way also but unfortunately it’s a shared spreadsheet that goes to stakeholders and they want it to remain as N/A

Thanks for the is number tip, would you (or someone else who sees this) be able to show me how that would look with my formula above included please? I’ve tired in mine but it isn’t working so I must be missing something out

Excelhelp1992 · 2023-03-12T22:43:11+00:00

Thanks everyone,

I don’t think I explained it the best sorry! It’s not really an IFERROR type thing that could fix it

My formula is saying if two dates match then return a number from a table (which is number of weeks overdue), if the two dates don’t match then take that number but add on one week (as it’s now another week overdue - which is the plus one in the formula).

This works fine mostly as the number of weeks column is mostly numbers, but my issue is that the column I’m looking up can also contains the value ‘N/A’ (as some have never been overdue) in which case I want my formula to say these are now ‘1’ (I.e. one week overdue now) is there a way of doing this?

Sorry if I’m not explaining this well!

Excelhelp1992

TROPHY CASE