J
jatman
i would like a list for data validation, but the list could be from different
tabs.
with validation criteria, allow custom:
=INDIRECT("'"&VLOOKUP(H5,Suppliers!A:B,2,FALSE)&"'!$a:$A")
all data will be in column A, but different tabs. when i use the above
formulae, i get an error message indicating that i cannot use references to
other worksheets or workbooks for Data Validation criteria. But if i use the
formula "=items" it references the list from a different worksheet.
any suggestions to get past this?
tabs.
with validation criteria, allow custom:
=INDIRECT("'"&VLOOKUP(H5,Suppliers!A:B,2,FALSE)&"'!$a:$A")
all data will be in column A, but different tabs. when i use the above
formulae, i get an error message indicating that i cannot use references to
other worksheets or workbooks for Data Validation criteria. But if i use the
formula "=items" it references the list from a different worksheet.
any suggestions to get past this?