Excel help to query few columns

Posted on 2012-09-17
Last Modified: 2012-10-14

Desktop sheet "AP" has to match Temp sheet "A"
Desktop sheet "L" match with temp sheet column "C"
If same then split the temp sheet colum "E" data into 3 parts and paste in desktop sheet
Yes as you said I want to split the temp sheet "E" into 3 parts and place them in "R,X,Y" columns

Color the rows on which have been updated with a color so i know what are the changes

The whole goal is match the employee id and machine name nd update the location of the users

Its a user database that i want to update

people have moved from one building to 4 other buildings
Hope this answers all your questions
else please buzz me will try to rephrase

Attached file
Color all rows that were updated in desktop and temp sheet
Question by:bsharath
    1 Comment
    LVL 30

    Accepted Solution

    Here is a go!
    Using lookup for the first condition then IF function for the second condition.
    Example for 1st row
    R: =IF( LOOKUP(AP2,Temp!$A$2:$A$7,Temp!$C$2:$C$7)=L2,MID(Temp!E2,1,2),"")

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now