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)?
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)?
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" <[email protected]> wrote in message
news:[email protected]...
> 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)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks