Netsing in IF Function (Excel97)

  • Thread starter Thread starter PeteV
  • Start date Start date
P

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
 
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)
 
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
 
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 :
 
Back
Top