I'm using vLookup to cross reference data from another spreadsheet. I'm not having issues getting the formula to work but this is an on-going spreadsheet so I need to fill the cells below for continuing updated information. How do I write the formula/function so that there is no text in the cell until the information is entered into the other spreadsheet? The current formula that works is =VLOOKUP(B5,[Test.xlsx]Sheet1!$B:$G,6,0).
Bookmarks