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
|