Vlookup in Excel

I need to Vlookup Parts qty inwarded for the perticular day into master sheet.

  1. in inwarding sheet, Data table contains, Part Number and Qty
  2. In master sheet, Data table contains Part number and inwarding details on datewise.

So how to vlookup the data from inwarding sheet of X day to X column of master sheet?

If you have the information stored as data tables that you’ve already read in, you could use the join data tables activity.

If you are doing the activity in the Excel workbook itself, you would probably need to write the formula to the column in question. This is more tedious in my opinion, but figure out the formula, then write it to each cell, or as a range.

Hello Nagaraj,
Here I have multiple ways how to do VLOOKUP (including multiple files):

Thanks,
Cristian