Vlookup + Hyperlink + IFERROR

As of a day or two ago, I've never used excel but my company needed a program to keep track of who enters and exits the building. Our ID badges have barcodes that store our ID # and so far I've made a spreadsheet that displays our Name, ID and position when the barcode is scanned, however I also want to display a image of each employee. I haven't been able to figure out how to make our picture appear in a cell next to our information but I have managed to get it to display a link to the image on our network drive. The problem is, when no ID # is loaded in the first cell, the link column is littered with #N/A. I'm trying to add IFERROR into the formula but it's not working. Here is the formula.

=HYPERLINK(VLOOKUP(B7,Information!$A$1:$F$101,6,0),"Click for Photo")

Can someone please assist in keeping that code from displaying #N/A before the ID # is scanned in?

If anybody know's how to add pictures so they would appear in a cell once the ID is scanned, that would even better. Thanks.

I'll attach the spreadsheet if it helps.

You could do it this way:

=IF(B7="","",HYPERLINK(VLOOKUP(B7,Information!$A$1:$F$99,6,0),"Click for Photo"))

or like this:

=IFERROR(HYPERLINK(VLOOKUP(B7,Information!$A$1:$F$99,6,0),"Click for Photo"),"")

Hope this helps.

Pete

Wow, thanks.

You're welcome - glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete