Thread: table look ups
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frances Frances is offline
external usenet poster
 
Posts: 10
Default 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