vlookup issue

[roelofB2014]

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

[rcm]

No vlookup only searches in the leftmost column so is searching in column C only

[FDibbins]

rcm, that is not strictly true, there is a way to use vlookup() and look to the left of it, but it is an advanced formula, so we just suggest index/match for that.

Roelof, which column do you want to use for the Assety tag? you have 2, but that asset tag (eu202312) actually isnt in either column

[rcm]

Thanks Fdibbins, I have only used unadvanced vlookup

[roelofB2014]

Hi ford,

in sheet csv its colom C where the asset tags are. so what i need is that when i fill in the name of an end user it shows the same data but search by asset tag must be working also.

[Richard Buttrey]

Hi,

You can't have a VLOOKUP in C7 User Name for when you choose to select an asset tag and then manually enter a User name and expect the Asset tag, which doesn't have a formula, to work. You'd need a sheet change macro to do that. i.e.

Please Login or Register  to view this content.

[roelofB2014]

Hi richard,

in the original file in the first sheet (show list) was a macro, see below

Please Login or Register  to view this content.

So what can i do best, make e new sheet special for name lookup or build in the code. Im a bit new with vba coding, if you can explain a bit of how the macro workes i would be gratefull, i like to learn

[Richard Buttrey]

Hi,

If that original macro is still relevant, then put the code I gave you inside the same procedure. It probably doesn't matter where as long as it's before or after the existing code, and obviously before the Exit sub instruction.

[roelofB2014]

Richard thanx for the reply,

im going to this afternoon and let you know how it goes.
I hope it works. I mean it works fine for me on asset tag search but some think its handy to have name search also....

roelof