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!