Input range and link a cell

[Jane]

Our employees need to record mileage between buildings. We have a workbook
with two sheets; daily travel and mileage grid of distances between
buildings. On the daily travel sheet they put in building codes (From-To)
and get the mileage from the grid. I'd like to automate it so when the
From-To codes are entered, the mileage from the grid is automatically
entered. Example: A1=BldgA B1=BldgD C1=mileage from grid. ....Note: A
Format Control on a form works, but there are several dozen entries, so this
is too cumbersome.

[Sandy Mann]

Jane,

With the list of buildings in C2:G2 and again in B3:B7 try using the
formula:

=OFFSET(B2,MATCH(H13,B2:B7)-1,MATCH(I13,B2:G2)-1)

to extract the data from the data contained in the table

--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"Jane" <Jane @discussions.microsoft.com> wrote in message
news:269352A7-6F8E-405A-911F-AAD7F0B19CCB@microsoft.com...
> Our employees need to record mileage between buildings. We have a
> workbook
> with two sheets; daily travel and mileage grid of distances between
> buildings. On the daily travel sheet they put in building codes (From-To)
> and get the mileage from the grid. I'd like to automate it so when the
> From-To codes are entered, the mileage from the grid is automatically
> entered. Example: A1=BldgA B1=BldgD C1=mileage from grid. ....Note:
> A
> Format Control on a form works, but there are several dozen entries, so
> this
> is too cumbersome.