Thread: Lookup Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kmwhitt kmwhitt is offline
external usenet poster
 
Posts: 36
Default Lookup Function

I have a simple table with 4 rows and 3 columns on one worksheet - A4:C7. On
another worksheet I would like to lookup a value from the table and have it
show up in cell F2. The column and row headings are NOT numbers. They are
text, so I don't think HLOOKUP or VLOOKUP will help. Correct? What function
is best suited to accomplish this?

Thanks,

Kevin