hi all,
I'm working with a file where there are a range of numbers in one column and I need it to look for that range of numbers and enter a specific text in another column.
Example
Column B will contain numbers 50xxxx,55xxxx,70xxxx,90xxxx,92xxxx.
numbers between 50xxxx-55xxxx require the text "cat"
Numbers that start with 70xxxx require "dog"
Numbers between 90xxxx-92xxxx require cat dog.
An IF function will work adequately...
=If B1 <56000,"Cat",If(B1>89999,"Cat Dog","Dog"))
Assuming there are no values outside of the ones you listed in your example.
Going for Guru! Click the Star to the bottom left of this post if I helped!
Does xxxx represent a numeric or alpha string?
Try
=IF(AND(B1>=50XXXX,B1<=55XXXX),"CAT",IF(AND(B1>=70XXXX,B1<=71000);"DOG",IF(AND(B1>=90XXXX,B1<=92XXXX),"CAT&DOG",""))))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Numeric and the values vary. Anything between 500000 and 520000 would be one set (dog)Originally Posted by Pepe Le Mokko
This worked. Thanks!
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks