Formula to add data from table in seperate worksheet, if cell contains, then add....

[Shayla]

I have a table set-up in a worksheet (see sample of table below)

Column A:
Teacher
Anderson
Anthony
Atkinson
Bausman
Byrne

Column B:
Prep
A3/B3
A2/B1
A3/B4
A4/B1
A1/B3



In a separate worksheet, is there a formula for the following:

For all cells containing the text "Anderson" add the text "A3/B3" to the next cell (cell to right of cell containing "Anderson")

...And so on for the rest of the teachers in the table?

[Pete_UK]

Assuming your names on the second sheet are in column A starting with A2, put this in B2 of that sheet:

=VLOOKUP(A2,Sheet1!A:B,2,0)

then copy down.

Hope this helps.

Pete

[Shayla]

Thank You Pete,
That worked perfect! That will save me hours and hours of time at work!!

Thank you so much,
Shayla