G
Guest
I created a drop down list using Data Validation (cell C6) from data that I
linked from another workbook onto this worksheet in this workbook. I created
a VLookUp that looks up the value from C6 to return a value in B8:
=VLOOKUP($C6,'By Case'!$A$2:$E$200,2). The formulas work fine, but the
values do not automatically show unless I double click into cell B8 and press
enter. I've tried updating the link, but that didn't do it. Please advise!
Thanks!
linked from another workbook onto this worksheet in this workbook. I created
a VLookUp that looks up the value from C6 to return a value in B8:
=VLOOKUP($C6,'By Case'!$A$2:$E$200,2). The formulas work fine, but the
values do not automatically show unless I double click into cell B8 and press
enter. I've tried updating the link, but that didn't do it. Please advise!
Thanks!