K
Kstalker
Morning all.
A simple function for most of you but one that I have never had to do
before... I need to look up a data set that is refreshed daily and
paste a value that meets the criteria into the same sheet.
I will have a data import running into the same worksheet that the data
is to be pasted into as below.
A B C D
type1 old 123
type2 old 456
type3 new 789
I need to match the two criteria ie type2 and old to get 456.
Then match type2 and B in the same worksheet as well as yesterdays date
in another area of the sheet and paste the value accordingly.
21/2/2006 22/2/2006 23/2/2006 24/2/2006 etc.......
type1 new
type2 old 456
type3 old
type4 new
Any help is as always greatly appreciated.
Regards
Kristan
A simple function for most of you but one that I have never had to do
before... I need to look up a data set that is refreshed daily and
paste a value that meets the criteria into the same sheet.
I will have a data import running into the same worksheet that the data
is to be pasted into as below.
A B C D
type1 old 123
type2 old 456
type3 new 789
I need to match the two criteria ie type2 and old to get 456.
Then match type2 and B in the same worksheet as well as yesterdays date
in another area of the sheet and paste the value accordingly.
21/2/2006 22/2/2006 23/2/2006 24/2/2006 etc.......
type1 new
type2 old 456
type3 old
type4 new
Any help is as always greatly appreciated.
Regards
Kristan