If Formula Help

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am hoping someone is able to help me figure this out. I'm feeling beaten by a spreadsheet right now.

Okay so I have created a drop down list in Column A. What I want to do in Column B is when the Name in Column A matches the name is Worksheet 1 Column C then Column B equals the Value of Worksheet 1 Column F. How Do I do this

I was trying to enter this and I continue to get errors I don't know how far off I am.

=IF(B4=Prices!A6,Prices!F6,0)OR IF(B4=Prices!A7,Prices!F7,0)(OR IF(B4=Prices!A8,Prices!F8,0))

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
No idea what you asked or were doing Looking at your statement, looks like if statement is wrong

=IF(OR( cond1, cond2, cond3...), <show this if either cond was true>, <show this if neither condition was true)