Search specific text in a number of worksheets using VLOOKUP

[davygryan]

Is it possible to use the VLOOKup function to check through a workbook containing a number of worksheets and return various values.

What ineed to be able to do is check various Worksheets for a specific text and then return the various results and the associated information on the same row.

If this isnt possible what could I use to do it

 

[JackDanIce]

Generally speaking no. A macro would be better suited for this

 

[davygryan]

Generally speaking no. A macro would be better suited for this

I have no experience whatsoever using MAcros. Is ths something that can be done easily enough?

 

[JackDanIce]

If you detailed your requirements clearly enough, myself or someone on this board, probably could write you one. You'd just then need to copy the code into a module within your workbook and then run it.