We help IT Professionals succeed at work.

Excel 2007 - How do search for an IP in another worksheet and pull additional information?

Medium Priority
202 Views
Last Modified: 2012-05-12
Hello,

I have a mass spreadsheet for SMTP Relay IPs and here what I'm hoping to do.

I would like to be able to create a formula that does the following:

If the IP in Current Tab A3 = Range of IPs [B3-B1858] then copy server name within D to current Tab

Comment
Watch Question

Commented:
So you have two worksheets in the same .xls file, right? and you want to search sheet2 for an IP that is currently in sheet1,right? If the IP is in sheet2 then copy data from sheet2 into sheet1 next to the IP that was searched. Is all this right, if not could you explain your question or provide sample data?

Author

Commented:
2 worksheets within the same xlsx file.
Example:
I have an IP of 10.0.0.0 within a WorkSheet in A3
I want to search the list of the all the IPs listed on another worksheet called 'All Global IPs' within the Listed other IPS - B3-B1858

If the formula matches the IP of 10.0.0.0 from cell A3 within the range on the other worksheet then the it will copy the information from 'All Global IPs' worksheet cell D to show the SMTP Relay server it using

If A3 = 10.0.0.0, Range All Global IPs! B3-B1858
Show lets say 10.0.0.0 = All Global IPs! B3 then I want to copy the cell information from D3 which is the SMTP Server name.  

Author

Commented:
any ideas?
=VLOOKUP(A3,'All Global IPs'!A2:C1857,3,FALSE)

Author

Commented:
figured out vlookup cmd

Explore More ContentExplore courses, solutions, and other research materials related to this topic.