Hello

I have a spreadsheet that was nicely formatted by a user whose values I need
to incorporate in  one of my MS Access reports.

Here is a sample layout of the excel file:

COLUMNS                   A        B        C        D        E
row 5     REGION 1     4000   5000   6000   7000   8000
row 7     REGION 2     100     200     300     400     500
row 9     REGION 3     800     700     600     500     900

row 12     REGION 4   55000 40000 36000 77000 88000
row 16     REGION 5   2500   1400   1700   1000   1500
row 20     REGION 6   9800   8700   7600   6500   1900

I am unable to import into MS Access because the excel file have several
headers from rows 1 to 4. And in between the region are additional titles.
Is it possible to lookup values instead of importing them?

TIA!