I am running a formula in an Excel spreadsheet that will Lookup data in a column of cells and display the data from two separate Excel Tables. The data is being retrieved correctly, but, if the 'main' column is blank (column B)...then the remaining row cells should be blank as well.
Columns C through E will retrieve data from Bi_Fuel_Vehicle table when there is no respective data in List_07 table.
I have a separate cell formulas for three different columns that render blank row cells. This formula is as follows and functions correctly. It is only here as an example:
Thank you in advance,