Hi All
i am have a data validation list in H4. in J4 i am trying to get a email address from another worksheet.using =VLOOKUP($H4,'Naming Sheet Folio'!$B2:$F62,5,TRUE).
the email address are in column 5. the names in H4 come from another worksheet.
any ideas why it returns a 0 and not the email address.
any help
Thank you
kind regards
Mark
Bookmarks