Data Fill Function - Question - Is This Possible?

Question

I'm back again seeking a similar answer for a similar issue I posted about a few weeks ago. My original post:

"I have two excel spreadsheets.

One excel spreadsheet is a price list containing prices and descriptions of items, and the other spreadsheet is blank.

I want to be able to open the blank spreadsheet, and using a barcode scanner scan items in my store, and have it autofill the description and prices from my price list spreadsheet and into the blank one. I intend to use this for repricing and reprinting labels throughout my store. 

Here's a step-by-step play of what I need to happen:

1. Scan a barcode (CODE 128) on one of our printed labels, and into the blank spreadsheet
2. The model number will pop up in the first cell of the blank spreadsheet, but I need it to autofill in the price and description fields as well (from the price list spread sheet)

Sorry, I'm trying to be as clear with this as I can.

Is this possible? 

Any help would be appreciated, if you have any other questions just ask"

The formula I was using for this is: =IF($A2="","",VLOOKUP($A2,[List.xlsx]Sheet1!$A:$D,COLUMN(B2),0)).... I just put it in cell B2 and dragged it where I needed it to go

That formula was working perfectly, but now I've combined my master price list spread sheet into one single sheet. I need to know if there is a formula where I can pull data from specific columns instead of it just autofilling in column order.

ACTUAL EXAMPLE:

In my blank scanning spreadsheet, columns A, B, C, D, E and F will directly correlate to columns A, K, L, M, B, and C.

With the formula I listed above, column A will fill in column A, B with B, C with C, etc.

Any help at is always appreciated. If any questions just ask

Answer 1

E for Excel,

You are truly awesome at what you do and I can't thank you enough for your timely responses and innovative solutions. I believe I have figured out what I needed to do but if anything else arises I will reply to your comment again.

Thank you and happy holidays

• Jonah

Answer 2

I remember providing solution to you. But as in the first time also, I would like to see sample workbook. Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and high quality solution.