Netsing in IF Function (Excel97)

[PeteV]

Want to have a look-up table where an user input
references a value. However, I am higher than 7 values.
Is there an easy way to have more than 7 nests without
splitting up each cell??

Thanks,
PeteV

 

[Frank Kabel]

Hi
no way to go behind this limit. You may consider creating a separate
lookup range and using VLOOKUP to get the values. e.g. create a table
like
A B
cond_1 value_1
cond_2 value_2
.....

Now you can use VLOOKUP as follows
=VLOOKUP(search_criteria,A1:B10,2,0)

 

[Guest]

Thanks. If I took a few minutes to search some historical
threads, I would have seen this solution before. I did
indeed use the VLOOKUP.

PeteV

 

[jago25_98]

If possible could you post your lookup formula here?

I'd find it really useful as a reference to the syntax.

Thanks if you can :