Looking up data from a non static cell

**Cherian George** · 12-02-2009, 12:28 AM

Hi Everyone,
I'm a novice when it comes to MS excel, however i do use excel 2007 quite a bit at work. I was working on one report and am stuck completely.
I have been running a web query and trying to extract interaction details from our reporting site onto excel. Depending on the time of the day the values keep adding on the subsequent cells when i refresh this web query. It populates other cells also which are have static values, however this static value cell keeps moving up and down based on the data that gets refreshed at different times of the day.
All i need as of now is to know how to lookup for the static value data in another sheet from this particular sheet as the cells/rows above this static value cell keeps moving up and down and is dynamic.
Please help!!!!!
Thanks

**darkyam** · 12-02-2009, 10:45 AM

Will the format always be the same? In other words, will FGHJKL always be 2 lines above the number you want? If so, you can use =INDEX('Web Query'!B:B,MATCH(C2,'Web Query'!B:B,0)+2).