How to Autofill one sheet based on a table made in another sheet.

Sure, I can help with that. You can use the VLOOKUP function in Excel to achieve this. Here’s how you can do it:

1. Click on the cell in Sheet 2 Column B where you want the value from the reference table to appear.
2. Enter the following formula: =VLOOKUP(A1, 'ReferenceSheet'!A:E, 2, FALSE)

Here’s what this formula does:

• VLOOKUP(A1, 'ReferenceSheet'!A:E, 2, FALSE) looks for the value in cell A1 of Sheet 2 within column A of the reference sheet. It returns the value in the second column (column B) of the reference sheet for the row where it found a match.

Please replace 'ReferenceSheet' with the actual name of your reference sheet.

Remember to press Enter after typing the formula. Excel should now display the corresponding value from the reference table in the selected cell of Sheet 2 whenever there’s a matching value in Column A.

If you want to fill columns C, D, and E as well, you can use similar formulas. Just change the third argument in the VLOOKUP function to 3 for column C, 4 for column D, and 5 for column E.