Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel advanced conditional editing help needed


17 Dec 2013   #1

Windows 7 Ultimate x64
 
 
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 System SpecsSystem Spec
.

17 Dec 2013   #2

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

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 System SpecsSystem Spec
17 Dec 2013   #3

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64
 
 

I agree - VLOOKUP is the tool to use for this.
My System SpecsSystem Spec
.


Reply

 Excel advanced conditional editing help needed




Thread Tools



Similar help and support threads for2: Excel advanced conditional editing help needed
Thread Forum
excel 2010 conditional formating Microsoft Office
Excel Guru Needed - Help with order form that will update an inventory Microsoft Office
Solved Some little help on editing this needed Customization
MS Excel Urgent Help Needed Microsoft Office
Cant scroll while editing formula Excel 2007 Microsoft Office

Our Sites

Site Links

About Us

Find 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 09:59 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33