Problem with Formula

[JennOlsen]

Good Morning Experts!

I am trying very, VERY, hard not to boot excel and my computer right out the window right now...

I have a formula that I've used for awhile now, and it always works. In fact, I got it from someone here.

However, today, on this new sheet, it is giving me grief, and I don't understand why.

My formula is: =IFERROR(INDEX(PT[HR Pay Tech Name],MATCH([@Unit],PT[Unit '#],0)),"")

But when I use it on my new spreadsheet, I get a message from excel telling me there's a problem and starts talking about apostrophes!

I've tried c&p for the formula. I've tried typing it in. I've tried copying my work to a new worksheet and a new workbook. I've tried copying my data as values only... And every time, my formula fails!! WTH?!

When I get that stinkin' box, I click ok, and it highlights the section that says PT[HR. Is that where it's having a hard time with my formula? When I try to fix the formula by showing excel the areas, it seems to take the formula, but then doesn't give me any results!! And I know there are some.

Both sheets are formatted as tables. I'm hoping to not have to upload a sample, because to depersonalized the file will be a pain.

Anyhow, if anyone has some insight, I would greatly appreciate it!

[JennOlsen]

Ok... I guess it was something with the formatting. I tried a last ditch effort and I got it to finally work! I guess my formatting didn't match for my two columns of Units. Once I set them both up with the same formatting, I suddenly got results!

[sandy666]

Attach a sample workbook with error like you said. 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.

[JennOlsen]

Attach a sample workbook with error like you said. 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.

I figured it out already. Thanks!

[sandy666]

So mark thread as SOLVED

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.