Tieske wrote:
You might create a column on each sheet with all other data concatenated
and then compare those two columns

"thecdnmole" wrote in message
...

Two sheets of data, same layout, different numbers, if I do a vlookup,
how do
I get it to return the whole row of data, about a dozen columns? TIA!


Here's one way:

=VLOOKUP(lookup_value,lookup_table,{2,3,4,5,6,7,8, 9,10,11,12})

array entered

Alan Beban