Table Header Name with carriage return

sspatriots

Well-known Member
Joined
Nov 22, 2011
Messages
585
Office Version
  1. 365
Platform
  1. Windows
I'm hoping this is an easy fix, but can't seem to get there.

I have the following line of code:
VBA Code:
=IF(ISBLANK(XLOOKUP([@[Cab
PO]],'PO Block History - DEM.xlsm'!Table7[COMPL PO NO CORR],'PO Block History - DEM.xlsm'!Table7[Date Received:])),"",

How can I get this all on one line without causing an error message. The reason it sows "Cab PO" jumping to the next line is because the header name has a hard return that puts it on the next line. I tried to use:

VBA Code:
"Cab" & CHAR(10) & "PO"

However, that did not work. Thanks in advance for any assistance on this.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
If the heading has a return, the formula is going to show the return.

If you want the formula to fit on one line, remove the return from the heading and then use Word Wrap if you want it to wrap to two lines.
 
Upvote 0
If the heading has a return, the formula is going to show the return.

If you want the formula to fit on one line, remove the return from the heading and then use Word Wrap if you want it to wrap to two lines.
Thanks, I just left it in there. I was trying to clean it up. If I use the wrap feature, some of the headers look strange because of the point at which the wrap around to the next row.
 
Upvote 0
Another option would be to use standard range references in the formula instead of structured table references, but the structured references have other benefits. Is this formula in the table, or outside of it?
 
Upvote 0
Another option would be to use standard range references in the formula instead of structured table references, but the structured references have other benefits. Is this formula in the table, or outside of it?
Inside the table. This table is very dynamic in that someone always wants to insert a column or delete one or add some to the end. That's why I went with the structured references.
 
Upvote 0
Well, that is definitely the benefit of structured references. Unfortunately I don't have a solves-it-all option for you.
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,106
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top