Forum Discussion
Need help with Excel Formula
Hi Everyone! I am the IT tech at a school and I need help with an Excel formula. Our school has about a thousand Chromebooks and a lot of them came from federal grants. I have 2 Excel spreadsheets. O...
Activate the first of the classroom sheets.
In B2 (assuming that row 1 contains headers), enter the formula
=IFERROR(VLOOKUP(A2, 'TAB 1'!$A:$B, 2, FALSE), "")
Replace TAB 1 with the real name of that sheet, then fill down to the last used row (for example by double-clicking the fill handle of cell B2).
Repeat for the other classroom sheets.