How to use Conditional Vlookup

[monskaye]

Hello i need help again

In my sample workbook there are 2 tables, a)7 days & b)28 days, there are different percent in 7 day & 28 day

i need help how to use vlookup if you will choose from 2 table..
EXample in:
curing time 28 days then
age 7
percent used is in table 28 days..

then example
curing time 7 days
then age 7
percent used is in table 7 days


pls refer to my sample book thanks!!

[Aardigspook]

Try this:

Please Login or Register  to view this content.

I've put in the error message 'check curing time' in case a number other than 7 or 28 is input into cell N15 - you could just return a blank instead, using "".

Edit: corrected formula in post 5 below

[monskaye]

Thanks aardigspook, formula worked other than the error message "check curing time" it doesnt work if i put value other than 7 or 28.

other than that its good. thanks a lot!!

[Aardigspook]

What do you want to happen if you put in a value other than 7 or 28? You only have tables for those values, but if there's some rule you'd like followed if you put in a value of 10 (for example), then I could amend the formula to deal with that.

(Thanks for the rep, by the way.)

Edit: sorry, looking again at the formula I gave you, I realise the error message won't work where it is. Use this instead:

Please Login or Register  to view this content.

Sorry about that - I shouldn't have posted it quickly without checking properly!

[monskaye]

Thanks so much!!

[Aardigspook]

You're welcome - glad I could help (after a false start ).

[Noah101]

Hi Aard I have a question IF(N15=7,3,IF(N15=28,5, on this part of the formula what does the "3" and "5" do?, what is this doing in the formula ?
I have a similar example so I found this interesting.

Thanks

Noah!

[AliGW]

It determines which column to return in the INDEX formula.