if trying to link the lookup to another sheet in the workbook what do you use to show the link between the sheets?
ex: lookup value of d12 in column a of the sheet "info" return value in colum "b"
=lookup(d12,a1$info$,b1$info$)
?? thanks for the help
and in the finished product can I hide the entire info sheet?
Bookmarks