Thread: vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default vlookup

Hi All

This vlookup formula is to be located inFinancialsO3

I have a Date on work sheet €˜FinancialsU2.This date will always be in
€˜FinancialsU2. I want to use this date in a vlookup function as my
lookup value
I want to look up in worksheet €˜financial itininary column c. the dates on
this worksheet start appearing in C475 advances on a daily every 49TH
row. When it is found the value I want to return is in column G. This figure
first appears in G479 and grows in value every 49th row.

I cannot get my head round the formula.
Hope someone can help

Stew