Choosing Cell ranges in embedded if statements

OK so here is a small sample of the code I am using. Basicly what it is doing is:
IF H2 on Sheet "OCT 8 - 13" = 200 then it will display "01REVN1020" in the cell. pretty straight forward, where I'm having trouble is I wan't the exact same code to work for H2 to H200. IF('OCT 8 -13'!H2:H200=200,"01REVN1020")

=IF('OCT 8 -13'!H2<200,"",IF('OCT 8 -13'!H2=200,"01REVN1020",IF('OCT 8 -13'!H2=201,"01REVN1020",IF('OCT 8 -13'!H2=202,"01REVN1020",IF('OCT 8 -13'!H2=203,"01REVN1020")))))

Use below and let me know if this helps to resolve your query.

=IF('OCT 8 - 13'!H2>=200,"01REVN1020","")

Thanks & Warm Regards,

Prasad Avasare

thank you for your reply. what I am looking for is to have that statement read the same for H2, H3, H4 etc...without having to write the code over and over. So instead of writing:

=IF('OCT 8 - 13'!H2>=200,"01REVN1020","")
=IF('OCT 8 - 13'!H3>=200,"01REVN1020","")
=IF('OCT 8 - 13'!H4>=200,"01REVN1020","")

these lines would all be combined into one line of code.
:-)

Are you looking for macro code? can you attach a file what you are exactly looking for.

User this formula =IF('OCT 8 - 13'!$H$2:$H$5>=200,"01REVN1020","") and hit ctrl+shift+enter

Thanks & Warm Regards,
Prasad Avasare

You are Brilliant... Thank you!!!!

@ Jaminman

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

OK, so it turns out the last post solved one problem but was not quite complete. if I enter the number 100 into H2 I get the result 1010 in my desired cell; however, if I enter the number 200 into cell H3 after, it returns the result 1010 as well where it should return the result 1020.
Whatever the result is in H2 is repeated no matter the number inputted.

Additional information that I'm not sure if may be causing a problem or is relevant.
The above mentioned code is on it's own sheet labeled "List". It is accessed from the page where the working spreadsheet is by using this code: =IF(H2>0,List!C2,""). So if H2 have a value greater that 0 it will access the formula on the List page.

Not sure if that makes sense.