Forum Discussion
Return blank if xlookup returns blank
RIght now B11 is returning a result from a blank cell, what I want is for it to return blank if C11 is Blank
This is what i'm currently using =IFNA(XLOOKUP($C11,'File Dump'!D:D,'File Dump'!B:B),"")
E and F are also using the same forumla but I can fix that if I can fix the above issue.
| Days Old | Pickticket | Wave # | Ship # | Ship Via | Customer Ship to |
| 81 | 5000101664 | 20240112090 | ONEN | BUMPER TO BUMPER CALGARY DC #12 | |
| 54 | 5000101617 | 20240105003 | 0000960876 | ONEN | MASLACK SUPPLY LTD-SUDBURY |
| 27 | 5000101634 | 20240112133 | 0000974822 | ONEN | AUTO PARTS CENTRAL WALL ST #1794 |
| 27 | 5000101716 | 20240106054 | 0000964405 | ONEN | BENSON AUTOPARTS |
| 26 | 7000251112 | 20231211100 | 0000920877 | ONEN | Motorcade Industries Inc. |
| 26 | 7000251120 | 20231219130 | 0000935742 | ONEN | WEST-CAN AUTO PARTS (IMPERIAL) |
| 25 | 7000251628 | 20231219137 | 0000935758 | ONEN | CANUSA AUTOMOTIVE WARE |
| 25 | 7000251627 | 20231219134 | 0000935752 | ONEN | LORDCO DISTRIBUTION CENTER |
| 25 | 7000251630 | 20231219135 | 0000935756 | ONEN | LORDCO PARTS (HEAD OFFICE) |
| 24 | 5000103080 | ONEN | MOBILE PARTS INC. | ||
| 24 | 7000257829 | 20231229194 | 0000951498 | ONEN | MOTORCADE INDUSTRIES LIMITED |
| 24 | 5000103080 | ONEN | MOBILE PARTS INC. |
- I've also tried
=XLOOKUP(C2&1,'File Dump'!D:D&--('File Dump'!B:B<>""),'File Dump'!B:B)
The Issue is there's a formula in the C column that seems to be the primary issue.Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Here's a test file that has the same formulas and similar set of data.
