Seach Value

[georgesme]

Hello ,

Can anyone help me with this plz
i need a vba code , that could do this job for me:

Search for the value of CELL "E31" on SHEET(4) , value is letters , not numbers

Search for this in a board or matrix , on SHEET(5) "A6:AA300"

And when it matches , it should display the text writen on the same row on column AB (starting "AB6")

This text is a person's name , and should be displayed in B33 of SHEET(4)

If there are many results , it doesnt matter if he picks one randomly..


Thank youuu

[stevebriz]

This should point you in the rihgt direction
Have look at the Find Method in the vbeditor help

[Leith Ross]

Hello Georgesme,

Here is the VBA macro code.

Please Login or Register  to view this content.

Sincerely,
Leith Ross