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

They are text, so I don't think HLOOKUP or VLOOKUP will help. Correct?

No, you can use TEXT in lookup tables. Try it!

Biff

"kmwhitt" wrote in message
...
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