Updating formulas (Range)

[STEVEB]

Hi All,

I was wondering if anyone new a way to update a formula using a range.

For example: Currently I have a formula that is as follows:

=IF
($C$4=202,C$4=12400,$C$4=12703,$C$4=34007,$C$4=50116,$C$4=50702,$C$4=61100)),"LA","N/A")

Each month the numbers (i.e. 202, 12400, 12703, etc.) change. Ther
can be anywhere from 4 to 40 of these numbers which I manually ente
into the formula each month. Is there a way to have the formula loo
at a range of numbers to check if any matches $C$4 so I can jus
reference a range rather than typing the numbers in the formula eac
month?

Any help would be greatly appreciated

 

[Frank Kabel]

Hi
try
=IF(ISNA(MATCH($C$4,X1:X10,0)),"N/A","LA")
where X1:X10 store your numbers

 

[Niek Otten]

I find it difficult to believe the formula you provided actually works.

Anyway, to check the presence of a number in a range of numbers, use the
VLOOKUP() function.
Check HELP for details. If you still have problems, post again!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel