• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Excel help to query few columns


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
1 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),"")
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now