hi guys and girls.

I have the following issue which drives me almost insane.

I have a worksheet which has as use showing asset data with vlookup. I fill in a Asset Tag and in the selected cells the other data which has been imported in the second sheet shows the info. I fill in by example EU201556 and then i see everything. Now the raised the question for searching on user name to show the data. so logically i thought because the vlookup sprain the whole sheet from A2 cell till BO1000 it shows the data but it doesn't.

I've tested on an empty clean sheet and there it did work. How can i make this work.

Also i like to import the ping option button which pings the asset tag given. Can anyone help me hereAssetLookup_airs_example.xlsm