Sounds like a two-dimensional table with values down the left side of the
table and values across the top of the table...you match a value on the left
and across the top and find the value where they "intersect", yes?
I've posted a sample workbook called INDEXMATCH-Simple.xls that you can
download and look at the simple examples of how these lookups are done.
https://sites.google.com/a/madrocket...edirects=0&d=1
You need the two-dimensional section.
Does that help?
--
"Actually, I *am* a rocket scientist." -- JB
(
www.MadRocketScientist.com)
Your feedback is appreciated, click YES if this post helped you.
"Bashful18" wrote:
I am working on a spreadsheet and I need a formula to look at eg: Column A
for a value and then Column G for a value and then look at a table of data
(column J-L) to calculate the result. Please help???