I have two sheets (A is ) history and (B is) forecast, I am doing Vlookup on sheet C, both sheets (A and B) column A is date and B is value, what I am looking on sheet C the vlookup by today date, for example, if today is 30 October, my vlookup bring all value from Sheet A till 29th October and from 30th October will bring from sheet C. any help
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,233
- Office Version
- 365
- Platform
- Windows
Does this do what you want?
=IF(A1 < TODAY(),VLOOKUP(A1,A!A:B,2,FALSE),VLOOKUP(A1,B!A:B,2,FALSE))
<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[ html]
<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[ code]<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[="" code]<="" html=""></today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[></today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[>
(Remove the spaces around the < - Forum seems to think it's HTML no matter what I do :-/ )
=IF(A1 < TODAY(),VLOOKUP(A1,A!A:B,2,FALSE),VLOOKUP(A1,B!A:B,2,FALSE))
<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[ html]
<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[ code]<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[="" code]<="" html=""></today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))<today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[></today(),vlookup(a1,a!a:b,2,false),vlookup(a1,b!a:b,2,false))[>
(Remove the spaces around the < - Forum seems to think it's HTML no matter what I do :-/ )
Last edited:
Upvote
0
