Hi I will try and make this as simple as I can.
I have 2 sheets, one with the name of a pc and its corrosponding IP adress.
The second sheet is with Version updates the pc's have, and ip adresses. I need the pc names here aswell. i have uploaded a excell sheet to explain.
The problem is there are multiple ip's of the same adress below each other at the version updates.
SHEET1
A B
Name IP
a 10.0.0.1
b 10.0.0.2
c 10.0.0.3
d 10.0.0.4
SHEET2
A B C
vrs ip pcname
1 10.0.0.1 should show a?
1.5 10.0.0.1 should show a?
2 10.0.0.1 should show a?
1 10.0.0.2 should show b?
1 10.0.0.3 should show C
1. 5 10.0.0.3 should show C
VLOOKUP Doesnt work. the prob is i need to get this dont by within 5 hours
I have 2 sheets, one with the name of a pc and its corrosponding IP adress.
The second sheet is with Version updates the pc's have, and ip adresses. I need the pc names here aswell. i have uploaded a excell sheet to explain.
The problem is there are multiple ip's of the same adress below each other at the version updates.
SHEET1
A B
Name IP
a 10.0.0.1
b 10.0.0.2
c 10.0.0.3
d 10.0.0.4
SHEET2
A B C
vrs ip pcname
1 10.0.0.1 should show a?
1.5 10.0.0.1 should show a?
2 10.0.0.1 should show a?
1 10.0.0.2 should show b?
1 10.0.0.3 should show C
1. 5 10.0.0.3 should show C
VLOOKUP Doesnt work. the prob is i need to get this dont by within 5 hours