Describe the layout of data in both sheets and give examples of the data and
what you want to achieve from those examples.

Pete

"Beverly Darvill" wrote in
message ...
Hi

I have two spreadsheets - one that has actuals and one that has forecast
values.

The one that holds the actuals figures takes them in from another
spreadsheet. The one that holds the forecast figures are exported from
another program.

What I need to do is to merge the two sheets into one. The first problem
is
the sheet that holds the forecast figures is not sorted in the same order
as
the sheet that holds the actuals.

I think I need to use HLookup but am not sure how.

Please help

Beverly