Trying to use one worksheet as data and do calculations on another, thus need to pull specific data from the data sheet to my calculations sheet.
Using the formula:
=VLOOKUP(C4&"",'List of Lists by name'!D:D,3,FALSE)
This returns the #NA error, despite my confirming the data is located in row...