See this screencap:

http://img100.imageshack.us/img100/4141/lookuper2.jpg

Biff

"Frances" wrote in message
...
I have a table of data that I would like to use both the hlookup and
vlookup
function at the same time to retrieve data. Column A is a listing of
codes,
and my column headings consists of 4 sizes. How can I write a formula
using
both a vlookup and hlookup at the same time? For example, in a
spreadsheet,
if someone enters a code in one cell and a size in the adjouning cell, how
can the formula return correct value from the table of data?

Thank you