IF and VLOOKUP

[CRAIG20]

Hi I have 4 tables: "days1, days2 ,days3 ,days4"

I have a cell B4 which contains a number.

I need a formula that if cell B4 = 30 it VLOOKUPs "days1"
if B4 = 31 it VLOOKUPs "days2"

Many thanks in advance.

Regards

Craig

 

[DanteAmor]

And what do you want as a result?
Can you explain it with examples?

 

[CRAIG20]

Hi. The existing VLOOKUP I have is: =VLOOKUP(B5,days1,2,FALSE) This works fine but only looksup 1 table.
What I need is a IF function so that if cellB4 = 30 it looksup table "days1"

 

[DanteAmor]

Try:

=VLOOKUP(B5,IF(B4=30,days1,IF(B4=31,days2,IF(B4=29,days3,""))),2,0)

 

[CRAIG20]

Try:

=VLOOKUP(B5,IF(B4=30,days1,IF(B4=31,days2,IF(B4=29,days3,""))),2,0)

That works perfectly. Thank you very much for your help.