sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 585
- Office Version
- 365
- Platform
- Windows
My table has a column with the header shown below:
Cab
PO
PO was moved to the next line when it was created by using the "Alt + Enter" key.
When I use the formula below, it works:
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab
PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
I would prefer that my formula didn't automatically wrap to the next line when I selected the lookup_value for the table column header, however, I realize that it is doing that because of "Cab" and "PO" being on two separate lines in the header. I tried re-writing the formula as follows:
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab & Char(10) & PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab" & Char(10) & "PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],["Cab" & Char(10) & "PO"]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab & Chr(10) & PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab" & Chr(10) & "PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],["Cab" & Chr(10) & "PO"]],Table7[#Data],14,FALSE)),"Is blank","not blank")
None of these will do the same thing as the original formula that was entered into the cell with the "Alt + Enter" to move "PO" down to the next line to match the column header. I need this to work this way because I want to put it into a macro formula to populate the cell for me at some point because sometimes we have people that will accidentally delete formulas or overwrite them. Any ideas how to make this work using something similar to the 6 formulas I've tried?
Cab
PO
PO was moved to the next line when it was created by using the "Alt + Enter" key.
When I use the formula below, it works:
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab
PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
I would prefer that my formula didn't automatically wrap to the next line when I selected the lookup_value for the table column header, however, I realize that it is doing that because of "Cab" and "PO" being on two separate lines in the header. I tried re-writing the formula as follows:
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab & Char(10) & PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab" & Char(10) & "PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],["Cab" & Char(10) & "PO"]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab & Chr(10) & PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],[Cab" & Chr(10) & "PO]],Table7[#Data],14,FALSE)),"Is blank","not blank")
=IF(ISBLANK(VLOOKUP(G2JobList[[#Headers],["Cab" & Chr(10) & "PO"]],Table7[#Data],14,FALSE)),"Is blank","not blank")
None of these will do the same thing as the original formula that was entered into the cell with the "Alt + Enter" to move "PO" down to the next line to match the column header. I need this to work this way because I want to put it into a macro formula to populate the cell for me at some point because sometimes we have people that will accidentally delete formulas or overwrite them. Any ideas how to make this work using something similar to the 6 formulas I've tried?