Hi everyone,
Hoping I can get some help with this. I have one summary sheet and two data sheets.
Summary sheet
Column A: a list of identifying numbers, i.e. RR001, RR002, RR003 etc.
Colume B: with show either Even or Odd for each corresponding number
Column C: a corresponding figure, i.e. 40, 50, 63, etc.
Data sheet1: has 2013 figures
Data sheet2: has 2012 figures
What I'm trying to do is have column C indicating the appropriate figure from data sheet 1 or data sheet 2. This is depending on whether column B is either Even (meaning sheet 1) or Odd (meaning sheet 2).
so it would be kind of like: if column B is Even, vlookup(A1, 'Sheet1!'A:B,2,FALSE); if column B is Odd, vlookup(A1,'Sheet21',A:B,2,FALSE)
Any suggestions?
Thanks everyone!!
Bookmarks