VLookup with a twist I run a web query which dumps all of the data into one colu

Question

VLookup with a twist

I run a web query which dumps all of the data into one column by 600 rows. Located within that data are days of the week spread out by several rows and what "rows" they land in are different each day I run the query. The problem I have is the data I need is always 7 rows below the day of the week and it is a temperature so the number is variable. So my question is, what function can I use to go down one column of data-find the day of the week I am looking for-then return the number that is 7 rows below it???

Thanks for help !!

Explanation / Answer

Hi..

I have assumed Column A, try this formula :

=INDEX(A8:A1008,MATCH(G1,A1:A1000,0))

In this formula G1 contains the lookup Day of Monday etc. Note the 2 ranges in bold are offset with the first starting 7 rows after the second.

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.