table look ups
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
|