Easy. Just make a copy of Enquiry. In the copy, change the criteria formula
in B2 to point to the ip col (col B in x), ie in B2:
=IF($A$2="","",IF($A$2=x!B2,ROW(),""))
Copy B2 down. Then change the DV in A2 to point to a named range for the
ips. That's it. No change is required to the rest of the extract formulas.
Hey, don't forget to press all the YES buttons, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"abadd0n" wrote:
Hey Max,

One more thing, if it possible to design the same database to fetch data
using hostname or ip.

Now there are times when we need to search data using ipaddress. Is it
possible to get a formula which get me data either from ip or hostname
whatever I type i the cell A2 of enquiry sheet?

abadd0n