VLOOKUP would be one way ..
Try Debra Dalgleish's nice coverage at her page:
http://www.contextures.com/xlFunctions02.html
(there's a sample book for d/l there)
Another way would be to use INDEX / MATCH
which Debra also covers at her:
http://www.contextures.com/xlFunctions03.html
(a sample book for d/l is available as well on the page)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jiri" wrote in message
...
What formula I should use to find a value of a specific cell in a defined
rectangular database table by a reference to the row ID (text) and the
Column
ID (number)?