Excel advanced conditional editing help needed


  1. plumpf
    Posts : 108
    Windows 7 Ultimate x64
       New #1

    Excel advanced conditional editing help needed


    Hi
    I have two excel files. One is inventory and other is ip plan.

    The inventory document has a alot of data. Of them One column is of computer name and second is ip.

    The ip plan has one column consisting of ip and next to it the user name and some other information.

    Now I want the ip plan document to also have a column for computer name.
    For this i will have to look at the ip column in ip plan file for first ip. Then search the inventory file for that ip. Once that ip is found in inventory file there is a machine name next to it. I will have to copy it and paste it next to ip plane file.


    How can i do it. Any clue? I have not used excel so deeply.
      My Computer
    Quote Quote

  3. Kaktussoft
    Posts : 10,796
    Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
       New #2

    Can you post both files, or are they confidential? Only few sample rows needed.... may be fake as well. Are you using excel2007?

    Are both lists ordered by IP (or are you willing to order by IP)?

    VLOOKUP is the function to use.
      My Computer
    Quote Quote

  4. Golden
    Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       New #3

    I agree - VLOOKUP is the tool to use for this.
      My Computer
    Quote Quote

 

  Related Discussions
I have a large list in a text file (roughly 900 items) and I want to do a few things to the list. First, I want to remove everything after a space on each line, including the spaces themselves. Then, I want to remove every line that does not have the either of these formats: ***kAA** ***kA**...
hello im trying to have a filter for specific text. i would like the cell to be green if : yes or ok are in the cell how can i do this ? i assume there must be various symbols for x AND y, x OR y
I was making myself a signature and all goes great and looks fine saved on my computer but when i upload it.It shows a white bar which it's not suppose to were it's suppose to be clear,i'm guessing i'm saving it wrong?Saved it as a .png,any help is appreciated.As you can see on the bottom it comes...
MS Excel Urgent Help Needed
in Microsoft Office

Hi, I need to create a spreadsheet for my project (don’t worry it’s not homework). I have put as much as I can together but there are a few challenging things that I am stuck on and I need your technical expertise. The below is what I need to add onto my spreadsheet – but I’m not sure how to do...
Hi I'm unable to scroll while editig a formula in excel 2007. i know it can be done if i edit directly in cell but i prefer editing in the formula bar. I've seen an apparent solution in some forum which says change the mouse setting in the control panel (the wheel tab). Start --> Settings -->...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 18:58.
Find Us