I thank you for reading and hope to see you next week. How does this formula work. Click on formula tab lookup reference click on vlookup.
If you change the column index number third argument to 3 the VLOOKUP function looks up the first name and returns the salary.
2 Excel VLOOKUP with 2 Tables of Values. We get a new function window showing in the below mention pictures. To start your VLOOKUP formula click an empty cell and then type an equals sign followed by VLOOKUP. In the following image youre seeing how I have made a formula using VLOOKUP and IF functions to choose one of the two table arrays.