Solved

# Find Data

Posted on 2011-02-21
184 Views
Hello, trying to find a way to locate 700mb in column a175:a250 and then located RH (%) in column b175:200, then take the data from that matched row and paste in sheet a50.  Sample attached
test11.xlsx
0
Question by:sandramac
[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
• 2

LVL 50

Accepted Solution

barry houdini earned 500 total points
ID: 34946071
Hello sandramac,

I put this formula in sheet2 A4 and copied across

=LOOKUP(2,1/(Sheet1!\$A1:\$A100=\$A2)/(Sheet1!\$B1:\$B100=\$B2),Sheet1!A1:A100)

where A2 and B2 contain the criteria

see attached

regards, barry
26837063.xlsx
0

LVL 42

Expert Comment

ID: 34946487
Wouldn't the range need to be rows 175 -> 250?

=Lookup(2,1/(Sheet1\$A175:\$A250=\$A2)/(Sheet1!\$B175:\$B250=\$B2),Sheet1!A175:A250)

or could also be written as:

=Lookup(2,1/(Sheet1\$A175:\$A250="700mb")/(Sheet1!\$B175:\$B250="RH  (%)"),Sheet1!A175:A250)

?

dave
0

LVL 50

Expert Comment

ID: 34946589
Hello Dave,

Well, on the attachment the data was in the first 20 rows so I went with that, I often add extra rows just to show that the formula can cope with the blank cells, obviously the ranges can be adjusted as required as long as they are all the same size.

regards, barry
0

Author Closing Comment

ID: 34975766
Thank you.
0

## Featured Post

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 Month4 days, 16 hours left to enroll