It might help if you posted your formula(s)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MEB310" wrote in message
...
I'm using vlookup to populate sheet 2 from sheet1. This is working for
part
of the spreadsheet, stops for 8 rows then continues working. According to
the Function Arguments the lookup result is true, but no update takes
place.
Is it possible to see the cell value it thinks it's returning? The data
in
ascending order as required.