I need some help with Microsoft excel

I need some help with Microsoft excel

Dear Marlin,

There is a function called vlookup in excel which can be used to compare data in two different excel sheets having some unique reference present in both the excel sheets. As in your case item number is present in both the sheets, you can use this field to map or compare the rest of the data in both the sheets. Enter = right besides the cell you want the data to be mapped from second sheet. Click on the insert functions menu.

Select Lookup & References in the Select a category drop down list. Then select VLOOKUP from it. The fields required in this function are:

Vlookup(row_num,column_num,abs_num,a1,sheet_text)

Id no of parts should be the leftmost column in both the excel sheets. In the buyer column on the first cell insert = and type vlookup( now it will ask you for lookup_value, your lookup_value will be the first cell of the id no of parts column in the above example it is A2.

Then it will ask you for table_array so after you insert the lookup_value enter a comma and then write the table_array that is the data you have to map against id no of parts in your second excel sheet. 

So after entering comma go to the second excel sheet by using the ALT tab function and select the whole column starting from id no of parts of the column where your buyers are listed. As shown below:

Know while selecting the columns just count the number of columns from the id no of parts column, the same is also displayed when you make the selection in the upper right corner. Enter comma now the next field is the col_index_num this will be the number of columns you counted as in the case shown it is 2.

Again enter a comma and the last field is the range_lookup enter 0 for it and close the bracket. All your data will be mapped against the id no of parts.

You can see the formulae in the status bar above for reference.