Hi! I need a formula that will look at the school name in column A and then look at the principal name in column D. The principal on sheet 2 coulumn D is different to return the the name of the new principal. I work with a lot of spreadsheets where the data is all over the place and I am looking for a formula that will allow me to say if row contains a school name on both sheets the pull the data from the specified column to match that school. Sample.xlsx
In E2 try:
=VLOOKUP(A2,Sheet2!A:D,4,0)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank You. That looks like it will work. Do you mind explaining where the 4 comes from so that I will know how to apply the formula to other circumstances?
The 4 means get the data from the 4th column in range A:D
That formula worked great for that circumstance. If I have more data and the school names fo not match exactly (sheet one says Adams and sheet 2 says Adams Elementary) do I need to tweak the formula to still get a match?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks