@RohanAbaHK Not completely sure what you are aiming to do, but from my understanding look at the example below for a recruitment service.
| candidate_name | application_id | assigned_value |
| John | A1 | 1 |
| Cam | A6 | 1 |
| Simon | A1 | 1 |
| Jenny | A3 | 1 |
The above table has distinct candidate_name in the 1st column, although there are multiple application_id. To get a total count of applications for each candidate, assign '1' as a value to each row on a new column (In this example the new column is assigned_value).
Use vlookup to and select the whole table in this case. It'll assign the correct application_id next to the candidate_name based on sheet1.
After that step, click on an empty cell anywhere and navigate to the 'data' tab. Then click on 'Consolidate' and select the entire table as in the above case we need to look up total applications for distinct candidates. Once you have selected the range, then click on 'add' within the 'consolidate' dialog box and then tick the 2 boxes, 'top row' and 'left column' and finally click on consolidate. Ensure to select 'sum' in the dialog box.
What this does is calculates the total applications for each distinct candidate. The top row contains the headers of the table and the left column is used to look up the total for each distinct customer.
It'll be more helpful if you could include an example of what it is you're trying to achieve with vlookup and provide an example as well. Hope this helps!
