IF Statement help needed....

forced

New Member
Joined
Jan 31, 2005
Messages
2
need to write an IF statement to calculate the following, The Data Column has numerous numbers in it which need to be identifyed as Sweet or Sour, In the Sweet and Sour columns there is all the numbers that are in the Data column identifying if there are Sweet or Sour.

This is what I tried, but didn't quite work.

=IF(M5=Q3:Q28,"Sour",IF(M5=S3:S51,"Sweet",))

The Type Column is where the IF statement would be displaying Sweet or Sour.



So I want a to right an IF Statement telling what they are, or perhaps a VLOOKUP table would be a better aproach???


Data Type Sour Sweet

100/01-21 ??? 100/01-21 100/01/35
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
A few rows of some sample data would be very helpful. I'm having trouble understanding exactly what it is you're looking for.
 
Upvote 0
So I want it to reference the Data and look in the Sweet and Sour Columns to determine what it is.....lots of info 100+ lines for every month of the year.

Data

100/01-21-039-13W4/00
100/02-10-042-13W4/00
100/02-13-040-14W4/03
100/02-30-039-13W4/02


Sour

100/02-10-042-13W4/00
100/02-36-040-13W4/00
100/04-31-040-12W4/02
100/04-31-041-12W4/00


Sweet

100/01-21-039-13W4/00
100/02-13-040-14W4/03
100/02-30-039-13W4/02
100/03-04-040-13W4/00
 
Upvote 0
Hi forced,

Something like this ?
Book1
MNOPQRS
2DataDataTypeSourSweet
3100/01-21-039-13W4/00DataType:Sweet100/02-10-042-13W4/00100/01-21-039-13W4/00
4100/01-21-039-13W4/00DataType:Sweet100/02-36-040-13W4/00100/01-21-039-13W4/00
5100/02-10-042-13W4/00DataType:Sour100/04-31-040-12W4/02100/02-13-040-14W4/03
6100/02-13-040-14W4/03DataType:Sweet100/04-31-041-12W4/00100/02-30-039-13W4/02
7100/02-30-039-13W4/02DataType:Sweet100/03-04-040-13W4/00
8DataType:None
Sheet1


Formula in N3 is : ="Data Type: "&IF(ISNA(MATCH(M3,$Q$3:$Q$28,0)),IF(ISNA(MATCH(M3,$S$3:$S$51,0)),"None",$S$2),$Q$2)
 
Upvote 0

Forum statistics

Threads
1,207,109
Messages
6,076,599
Members
446,215
Latest member
userds5593

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top