B
Beverly Darvill
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
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