yogi_Given IDs in Column A Lookup Value For Specified Fields From Another Tab

Google Spreadsheet   Post  #2568

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-06-2019

question by: Garrett M Yates:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/7I8JCC_1iS4;context-place=forum/docs
Quick question about VLOOKUP formula. Please and thanks! :)
Hello All,

I was very graciously provided with a VLOOKUP formula in a previous post to perform the following results on a "test" sheet:

Workbooks:
Master Copy

Slave Copy (1)

Slave Copy (2)

- I am using an IMPORTRANGE from workbook Master Copy to import only some data to each of the two slave copies.  Slave Copy 1 and Slave Copy 2 will therefore be operating slightly different tasks as well as displaying some custom info tailored to each workbook.

- I'm trying to figure out a formula that will be in place for Slave Copy 1, Sheet2, all of Column B (Item Name) that when a value is entered in a cell for Sheet2, Column A (Item Code) it's corresponding value from Sheet1, Column B will then automatically populate in Sheet2, Column B.

However, when I attempted to replicate it on my actual sheet that I wanted to use, I receive an error.  The actual sheet is listed below and the error is taking place on the second tab.

Actual Sheet

If anyone might be able to help with suggestions, that would be gratefully appreciated!

Thanks in advance! :)