How?

[jmo]

i'm selling real estate lots.....when i type in a lot
number i want it to display the cost of the lot next to it.
How?

 

[Harlan Grove]

i'm selling real estate lots.....when i type in a lot
number i want it to display the cost of the lot next to it.

See VLOOKUP in online help.