Input range and link a cell
 

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.

Input range and link a cell
 

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

with @tiscali.co.uk


"Jane" <Jane @discussions.microsoft.com wrote in message
...
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.