Vlookup to select a row ?

[No3ntry]

Does anyone know if you could create a macro in excel that would use a Vlookup to select an entire row ?

 

[Participant]

Not sure of your question as 'selecting a row' is accomplished by clicking a row number .

Have you considered HLOOKUP? It looks along a row and returns a value from the column in which it finds the text. Again, not sure what you are after as your OP is so terribly worded .

If you mean a VLOOKUP that sums all values along the row it finds the text in, then you could use SUMPRODUCT.

 

[Makhaira]

You can do it with macros, not sure of the code though I'm afraid. Is this to delete a row?

 

[Linkex]

If it helps, you can click and drag the vlookup from cell to cell, so you could populate A1 with row 1, then drag it across. Use '$' symbols on anything you don't want to change when you drag.

So, if your lookup was:
=vlookup(A1,othersheet!A:F,1,FALSE)
you could change it to:
=vlookup(A$1,othersheet!$A:$F,1,FALSE)
and it would still work as you move it around

 

[DogsBody]

using collegues account at work.

I want to get a macro in "spreadsheet 1" to look at cell C10 which will contain a value that matches one of the values in column A of "Spreadsheet 2" then select the apprpriate row then copy and paste values (the rows have vlookups and various other formulas that I basicly want the macro to remove and replace with the actual value instead)

Thanks
James