I have attached a sample spreadsheet. I need a lookup formula of some type in C3 that will look at the value in Column A3 (the version) and the value in C1 (will always be the reference for all formulas in column C. This is the position number) then goes to the worksheet named Actual Dates and finds Version in column A and the Position in column B then returns the corresponding date from Column C to the first worksheet named Comparison.
I tried a vlookup with an if statement but got an error message. Am I trying to get a formula to do too much?
Thanks!
Bookmarks