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???

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???