VLOOKUP/INDEX MATCH formula for finding cost of toner based on printer name & model

Use this formula in B1
=VLOOKUP(VLOOKUP(Table1[[#This Row],[Printer Name]],Example_Printers.xlsx!Table1[#Data],2,FALSE),Example_Printers.xlsx!Table2[#Data],COLUMN(),FALSE)
Copy to B1:C8

Table1[[#This Row],[Printer Name]]
This means the value from the row where formula is placed under the column head Printer Name

OK, so here I decipher the formula starting with the nested VLOOKUP.

=VLOOKUP([@[Printer Name]],Example_Printers.xlsx!Table1[#Data],2,FALSE)
This says that we want, in example, DFW_LZ.P59 (because that is the current row's value for Printer Name). So it will look in Example_Printers.xlsx Table1 for DFW_LZ.P59, and because of #Data it will search the entire table. Once it finds DFW_LZ.P59, we want COLUMN NUMBER TWO (we specified it as the third parameter col_index_num in the VLOOKUP). We also say it has to be an exact match.

So, this VLOOKUP's result is the Model # of the printer (which happens to be "HP LaserJet 400 M401dn")

Now we examine the parent VLOOKUP:
=VLOOKUP("HP LaserJet 400 M401dn",Example_Printers.xlsx!Table2[#Data],COLUMN(),FALSE)

We are looking for HP LaserJet 400 M401dn in the second table (the whole thing). We find it, and then .... COLUMN(). This returns the column number of the current field in Template.xlsx. In other words, sourabhg98 is expecting the Toner Part # and Toner Cost columns of Template.xlsx to be the same COLUMN() (column number) as in Table2 of Printers.xlsx.

Question
ok, so this is a problem. When I insert a new column between Printer Name and Toner Part # in Example_Template.xlsx, then the values for Toner Part # become the dollar values that Toner Cost was, and now Toner Cost shows #REF!. How can this be resolved?

Solution (I think)
I replace COLUMN() with the column number in Printers.xlsx for the same column name. There is a better solution than this though. I should be able to put together a VLOOKUP with what I have learned so far in this thread to find the column name in the other Excel workbook of a specific table using [#Data] and return the COLUMN() of that (or perhaps it is backwards -- COLUMN(VLOOKUP())?) I am having trouble putting together a formula for this. When I encounter col_index_num in COLUMN(VLOOKUP()) I don't know what to put.

In the real Template.xlsx and Printers.xlsx I actually have a lot more columns in both workbooks and tabs. I provided a simplified example here in this thread to make it easier to read and help me.

What this formula will do for me is allow me to calculate approximate printing operating expenses for the Company. I use PaperCuts Print Logger to log all print jobs to a CSV, then I import the CSV data into Template.xlsx (a pre-configured Workbook with a data table with additional columns calculating different things, pivot table, and pivot chart). I will implement this formula here, then I will be able to learn approximately how much the Company world-wide is spending on both paper+toner every fiscal quarter.

And if you must inquire, I calculate for toner based on estimated page yields of cartridge part #s. We ship toner to our users when they request for a toner cartridge, and likewise we keep track of each shipment so then that way we can perform cost analysis on printers based on "actual usage" (aka how many toner cartridges they request for a specific printer in a given time period) to determine if it is cost effective to upgrade specific printers to a more expensive, higher duty cycle printer.

I think by learning how to set this formula up --> breaking it down and analyzing why it works the way it does and how, I may be able to expand my works even further to correlate print job logs with the toner ship log.