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
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
sandramacAuthor Commented:
Thank you.
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
I put this formula in sheet2 A4 and copied across
=LOOKUP(2,1/(Sheet1!$A1:$A
where A2 and B2 contain the criteria
see attached
regards, barry
26837063.xlsx