Vlookup (or index/match) with multiple criteria over multiple sheets

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!!

Sure, with a little IF magic:

IF(what,do what when true, do what when false)

=if(B1="Even",vlookup(A1, 'Sheet1!'A:B,2,FALSE),vlookup(A1,'Sheet21',A:B,2,FALSE))