If text function when correct showing a corresponding value

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:)
 
How about:

Code:
=IFERROR(VLOOKUP(S2,'Sheet 2'!A:F,6,0),0)

Cheers,
 
Last edited:
Back
Top