Groovy Chick
Board Regular
- Joined
- Oct 10, 2017
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Hi, I have two tabs on a spreadsheet called LOPC and Tiers. From the LOPC file I have a formula that looks at the value in cell A2 and so on to find a match in column A on the Tiers tab and return the text in column C at the Tiers tab if it finds a match or no match if it doesn't. I am using the formula
This works insomuch as it returns No Match but it is returning No Match even when there is a match. Can someone advise me what I am doing wrong? Thank you.
Code:
=IFERROR(VLOOKUP(A2,Tiers!A2:C443,3,FALSE),"No Match")