I have a spreadsheet I use to track orders. Column P in my sheet uses a "vlookup" formula to show data in cells ranging from P40:P73. I want to reference all of the data in that range into another cell (call it cell A1) preferably with spacing or commas to separate the row data. I came close using a combo of "transpose" and "concatenate", but some of the cells in column P have no data to pull in from the 'vlookup' formula, so those cells return a 'N/A' result. If any cell in range P40:P73 returns an 'N/A' result, then the 'concatenate' function won't work and I get an 'N/A' result in cell A1. Is there a way to concatenate and skip or ignore 'N/A' result data?
Bookmarks