Anyone Good With Microsoft Excel? Technology

[Random Guy]

Is anyone good or more knowledgeable than me at using Microsoft Excel?

I have two reports, both are lists of printers with one column being the IP address.

I need to compare each report and highlight those on report A that are shown on report B by IP address, how the hell do i do it, both reports are on tabs in the same spreadsheet. I'm looking on Google but all this VLOOKUP stuff takes me down a rabbit hole and I don't seem to be getting the right information. I'm sure it's simple but can I hell work it out from the advice on the internet. Help!!!

 

[Boot Cleaner]

Sounds like it literally is just a simple VLOOKUP (evaluate to FALSE) and some conditional formatting to highlight where you get a value returned?

 

[Hollie]

Message me - I'll do it.

 

[Dylan]

Put filters on both tabs and sort them on the printer names. Make sure the IP column is to the right of the printer names.

Assuming you have
Tab 1 & Tab 2
Column A is printers, B is IP and C is blank

In C2
=Vlookup(A1, Tab2!A:B, 2, FALSE) will look to find the printer name in the other tab, and return you the IP from that sheet.

 

[Hollie]

Message me - I'll do it.

=IF(ISNUMBER(MATCH(B1,'List B'!$B$1:$B$1771,0)),"On List","Not on List")

B1 is the IP address you are looking up.

'List B'!$B$1:$B$1771 is the sheet and cell range of the list you are looking up.

 

[Dylan]

Put filters on both tabs and sort them on the printer names. Make sure the IP column is to the right of the printer names.

Assuming you have
Tab 1 & Tab 2
Column A is printers, B is IP and C is blank

In C2
=Vlookup(A1, Tab2!A:B, 2, FALSE) will look to find the printer name in the other tab, and return you the IP from that sheet.

I forgot to make clear, if it's there, it'll show it. Otherwise, it'll say "N/A".