Formula Help

[Bashful18]

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

 

[JBeaucaire]

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/madrocke...iles/IndexMatch-Simple.xls?attredirects=0&d=1

You need the two-dimensional section.

Does that help?