Something like this, with the appropriate cell refs fixed, and using an
incrementer [ eg he COLUMNS($A:A) ] for the col index param for easy
propagation as you copy across:
=IF(ISNA(VLOOKUP($A1,Sheet1!$A:$Z,COLUMNS($A:A)+1, 0)),IF(ISNA(VLOOKUP($A1,Sheet2!$A:$Z,COLUMNS($A:A) +1,0)),"",VLOOKUP($A2,Sheet2!$A:$Z,COLUMNS($A:A)+1 ,0)),VLOOKUP($A1,Sheet1!$A:$Z,COLUMNS($A:A)+1,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thecdnmole" wrote:
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!