Referencing Another Sheet

Bangert

I am entering data (BC23-111) in red block, and trying to reference another sheet to pull back the file name when there is a match of BC23-111. I keep getting a #UNPARSEABLE error message. I feel like I am close but cannot seem to get past this error. Any/all assistance is appreciated, thanks.

DKazatsky2

Hi @Bangert,

See what happens if you change the ";" (semi-colon) to "," (comma).

Hope this helps,

Dave

Bangert

Thank you. I made the change of ";" to "," with the same results :(

Bangert

Believe I figured it out, it was the ", 0" at the end...not sure why but it is working now.