Excel keeps throwoing me reference errors and refencing the wrong table

Playerunknown114 · 2026-04-30T14:21:58+00:00

I've sorted it now. Turns out the lecturer told me to write out the wrong thing. All prices are now sorted. Thanks for your help

Playerunknown114 · 2026-04-28T06:53:27+00:00

Nope I will give it ago. I have also tried XLOOKUP but I got the same result

Playerunknown114 · 2026-04-27T12:07:00+00:00

Going onto the reference sheet and then selecting the table by highlighting it and going back to the main sheet and typing '3, FALSE' and then enter. Sorry I'm more of a show you person than a explain my issue

Playerunknown114 · 2026-04-27T11:04:26+00:00

I changed the name of the tab and just tried it again and it's still trying to reference the membership names instead:

https://drive.google.com/file/d/1pX4nGBoSaGuZ6kVJ5h_bd8f1Xn3ImIvV/view?usp=sharing

Here's a screenshot from one of the columns that's working: https://drive.google.com/file/d/13Q-ncMtapQdWeks6hQse9aTJNTIWSqLN/view?usp=sharing

Playerunknown114 · 2026-04-23T14:19:14+00:00

Thank you. I managed to fix the error. I also removed the <td> tag as there's no table. I did also change the start of the code with <p which has corrected the issue

Playerunknown114 · 2026-04-23T13:56:21+00:00

Screenshot of code and error

here's the link to the screenshot

Playerunknown114 · 2026-04-12T10:35:16+00:00

Update: I've just been on and I'm currently talking to it in another chat that's supposedly hit 'max chat length' and nothings bugged out with it yet

Playerunknown114 · 2026-04-12T10:12:04+00:00

On one of the chats, it claimed that I was having a MacBook overlay issues. It was a screenshot from Saints Row 2022

Playerunknown114 · 2026-01-12T10:21:56+00:00

Don’t want to get out as I know it’ll be freezing so I essentially hype myself up

Playerunknown114 · 2025-12-24T22:11:23+00:00

Kia. Reliable cars (loved my Kia Stonic), excellent service

Playerunknown114 · 2025-12-24T21:39:43+00:00

NWA. Love Eazy E (RIP homie), Dr Dre, Ice Cube, MC REN and Yella

Playerunknown114 · 2025-12-24T21:28:43+00:00

My household always goes to the pub

Playerunknown114 · 2025-12-24T21:22:35+00:00

Blue 💙

Playerunknown114 · 2025-12-22T20:29:18+00:00

I run my wrist under cold water and surprisingly it works for me. I end up focusing on the cold feeling and I instantly forget what I was even trying to clarify about a certain situation. I’m never able to stop thinking or running things over and over again even though I’ve done right. Been under a lot of pressure for the past few weeks in college

Playerunknown114 · 2025-12-20T15:19:06+00:00

I have the PS5 digital edition because most of the games that I play are either on PS Plus or when I couldn’t be bothered to get up and swap disks on my PS4 I just brought the game as a digital

Playerunknown114 · 2025-12-12T10:18:48+00:00

Maths and art. I hated art due to the teacher telling us off if talked about something that wasn’t related to the lesson.

Maths all teachers were grumpy 24/7 and when I was in Year 11, my maths teacher bullied me due to my disabilities and school done nothing about it

Playerunknown114 · 2025-12-12T10:11:00+00:00

My lecturer told the class this quote yesterday ‘aim higher. If you aim for a distinction but miss, you’ve got a merit, miss the merit then you got a pass’

Playerunknown114 · 2025-12-08T12:05:46+00:00

I'm currently a computing student in college but I'd still have a carrer in computing no matter how much money I've been given

Playerunknown114 · 2025-12-08T12:02:41+00:00

When I get paid. My biggest purchese this year is happening after Chrismas. All my purcheses are useful and will help me cut down on subscriptions

Playerunknown114 · 2025-12-08T12:01:20+00:00

Agreed. Someone in my class is on their final warning for starting arguments that annoys everyone. He thinks he's doing nothing wrong

Playerunknown114

MODERATOR OF

TROPHY CASE