Pull data from another sheet if specified cells match

1. Pull data from another sheet if specified cells match

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

2. Re: Pull data from another sheet if specified cells match

In E2 try:

=VLOOKUP(A2,Sheet2!A:D,4,0)

copied down

3. Re: Pull data from another sheet if specified cells match

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?

4. Re: Pull data from another sheet if specified cells match

The 4 means get the data from the 4th column in range A:D

5. Re: Pull data from another sheet if specified cells match

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1