nested if statement using vlookup

[mdot218]

Good Afternoon all

I am having some trouble with a formula.

On sheet 1, cell B3 contains a date, cell D3 contains the word "day", or "night", cell B5 contains the formula below:

=IF(D3="DAY",VLOOKUP(B3,Sheet2!A5:C7,2,0),0)&IF(D3="NIGHT",VLOOKUP(B3,Sheet2!A5:C7,3,0),0)

If D3 contains "Day", the answer ends with '0',
If D3 contains "night" the answer starts with '0'

I know why, it is because I have put & into the formula.

Here is my problem, either I am using the incorrect functions to begin with, and if they are correct, I dont know how to nest them together correctly.

Any advice will be great.

Thanks

mdot218

[NBVC]

Try:

=IF(D3="DAY",VLOOKUP(B3,Sheet2!A5:C7,2,0),IF(D3="NIGHT",VLOOKUP(B3,Sheet2!A5:C7,3,0),0))

[mdot218]

thank you very much. glad to see I was on the right track at least.