RE: Nested if statement and vlookup problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

I dont think that is the problem
Have just run the example again using - fieldBoss 10" STD riser
incrementing the 10" from 1 - 13 in cells A1 - A13

all 3 formulae return expected results
ie Formula 1 returns 1 - 7 on the 1st 7 choices then FALSE ater that
Formula 2 - choice 1 - 7 = FALSE, Choice > 8 returns 8 to 13

Formula 3 returns the number every time

Have you tried running Formula Auditing on your 3rd IF formula when it
returns #VALUE ?

"Steve" wrote:

The reference cells, the combo box refers to contains text,
ie
Cell A1 fieldBoss 10" STD riser
Cell A2 fieldBoss 8" STD riser

etc
could that have anything to do with it?

"steve_doc" wrote:

Hi Steve

Having just run your example using basic information, I return the correct
information everytime.

Could it be a format Issue?

"Steve" wrote:

Hi folks
I am having a problem with nested if statements, and vlookup.
I have a combo box to select an item. The combo box is liked to a group of
cell, where the date for it is kept. the list is 13 items long. I then
perform a set of nested IF statements to work out a number for the item
selected.

this line is for the first half
=IF(E2=A1,1,IF(E2=A2,2,IF(E2=A3,3,IF(E2=A4,4,IF(E2=A5,5,IF(E2=A6,6,IF(E2=A7,7)))))))
this line is for the next half, there are no macro's on this ***. and it
is virus free.

thank you to anyone who is able to help me out
=IF(E2=A8,8,IF(E2=A9,9,IF(E2=A10,10,IF(E2=A11,11,IF(E2=A12,12,IF(E2=A13,13))))))
and this line selects the number
=IF(E5,E5,E6)

E2 holds the combo box
the data for the combo box resides in A1:A13

Here is the problem.
the value returned from the the selection formula either comes up with
#VALUE! or the correct number.
I then perform a Vlookup to get some more data and I either get a return of
#N/A or #VALUE!.

I have spent the majority of a day trying different ways of doing this but
still have this problem. I have an XLS work*** available by email if you
want to see the problem in action. Please just email me at

buffyangelus@xxxxxxxxxxx

and I'll be more than happy to email it to you
.

Quantcast