You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- Array- performing 2 column lookup
Excel/Array- performing 2 column lookup
Advertisement
Question
I have a multi-worksheet file.. on the first worksheet I am trying to perform a two-column lookup using an array formula. Here is the formula {=INDEX(Rate,MATCH(B8&B7,OHpool&SalGrade,0))}
The named ranges Rate, OHpool, and SalGrade are on another worksheet. The cells B8 and B7 are on the same worksheet as the formula. Cell B8 reflects one of the OH Pools in the named range of OHpool and Cell B7 reflects oneof the Salary Grades in the named range of SalGrade. I want the formula to return an hourly salary rate from the named range of Rate. The formula seems to be showing as text... not a formula when I use the parentheses. Help.
Kath
Based on how the formula is written--I am not understanding what the formula is trying to do. I might suggest that the terms using & to combine cells I.E. B8&B7, will produce a text valued cell, and maybe thats the problem, but I really can't tell.
I suggest you reask the question of another allexperts person and I'm sure you can get a good answer.
Sorry I couldn't be of more help
Richard
USA
Florida
Related Articles
- Excel Named Range - Using a Named Range in Excel - Excel Named Range
- Excel 2010 Tutorial - Excel 2010 Step by Step Tutorial - Excel 2010 Spreadsheet Tutorial
- Microsoft Works Spreadsheets Tutorial - Microsoft Works Spreadsheets Step by Step Tutorial
- Excel Format - Excel Format Options Step by Step Tutorial
- How to Use Excel Formatting - Excel Formatting Tutorial Data
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Richard Roberts
Expertise
Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.
Experience
Have been working with Excel for about 15 years primarily in accounting and financial areas.
Education/Credentials
BA, CPA
©2012 About.com, a part of The New York Times Company. All rights reserved.