I am looking a formula to retrieve next record of vlookup. Let me clear.
my Source Sheet is this; (not sorted by name; there may be same names in cells after some other names)
ID NAME IP
12 GAZAY 10.210.1
12 GAZAY 10.210.2
13 RAFOR 10.210.18
My destination will be like the following;
ID NAME IP
12 GAZAY
12 GAZAY
12 GAZAY
12 GAZAY
13 RAFOR
13 RAFOR
If i am clear till here, what i need to do is this: I will vlookup the ip adressess it should bring me the all records every time, but in my destination sheet i have four (4) same name "GAZAY" however in source sheet i have two "GAZAY" name. So if available i need to vlookup and bring the allrecords when it is not available it should give me #NA or something not available string.
I hope it is understandable, sorry my poor language
briefly:
my source page is this: http://imgim.com/7775incix1891334.png
What i need is this: http://imgim.com/1793incia8944647.png (it should find all ip adressess if available)
Thanks in advance, and i appreciate
my Source Sheet is this; (not sorted by name; there may be same names in cells after some other names)
ID NAME IP
12 GAZAY 10.210.1
12 GAZAY 10.210.2
13 RAFOR 10.210.18
My destination will be like the following;
ID NAME IP
12 GAZAY
12 GAZAY
12 GAZAY
12 GAZAY
13 RAFOR
13 RAFOR
If i am clear till here, what i need to do is this: I will vlookup the ip adressess it should bring me the all records every time, but in my destination sheet i have four (4) same name "GAZAY" however in source sheet i have two "GAZAY" name. So if available i need to vlookup and bring the allrecords when it is not available it should give me #NA or something not available string.
I hope it is understandable, sorry my poor language
briefly:
my source page is this: http://imgim.com/7775incix1891334.png
What i need is this: http://imgim.com/1793incia8944647.png (it should find all ip adressess if available)
Thanks in advance, and i appreciate