Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Perform a search in an array, return an offset value

Posted on 2015-02-20
Medium Priority
114 Views
In the attached workbook, the worksheet has the data I am trying to work with.
In Row J34:AD34 there is either one of the following values: 30%, 60%, 90% The rest of the cells contain #N/A

I need to figure out how to search through the cells, find the corresponding value; 30%, 60%, or 90% and return the date value from 17 rows above. (J18:AD18)

=IFERROR(MATCH(0.9,J34:AD34,0),"") will give me the position in the range, but I can not figure out how to relate that to the actual column number to offset from.

Any ideas?
Problem.xlsx
0
Question by:DougDodge
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 24

Accepted Solution

Phillip Burton earned 2000 total points
ID: 40621495
0

Author Closing Comment

ID: 40621563
Your solutions are perfect as always...... Thank you.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
###### Suggested Courses
Course of the Month8 days, 19 hours left to enroll