erichatton
New member
- Joined
- Aug 11, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I am looking to make a function where when B2 equals the text in any cell in column A of sheet 2 then it shows the corresponding number in column F of the same row in which it matched. If not then input a zero. Ex. if B2 says McDonalds then of the other page A254 says Mcdonalds, then number in F254 appears. This is what I have so far but could be completely off =IF(B3='Sheet 2'!A:A,'Sheet 2'!F:F,0).
Any help would be awesome
Any help would be awesome