Excel Formula Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-2858896%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2858896%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20is%20there%20a%20formula%20to%20cross%20reference%20a%20name%20from%20TAB2%20Column%20H%20to%20TAB1%20Column%20C%20even%20though%20they%20might%20not%20be%20in%20the%20same%20cell%2C%20then%20confirm%20in%20TAB1%20Column%20F%20if%20there%20is%20a%20match%20how%20can%20I%20get%20it%20to%20list%20it%20as%20active%20in%20Column%20F%3F%20I've%20used%20a%20Countif%20before%20but%20I'm%20obviously%20doing%20something%20wrong%20as%20its%20not%20reading%20how%20I%20would%20like%20it.%20Any%20help%20appreciated%20thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Porcha_0-1634596905552.png%22%20style%3D%22width%3A%20574px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F318227i048195B3C25A23D4%2Fimage-dimensions%2F574x370%3Fv%3Dv2%22%20width%3D%22574%22%20height%3D%22370%22%20role%3D%22button%22%20title%3D%22Porcha_0-1634596905552.png%22%20alt%3D%22Porcha_0-1634596905552.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2858896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2859487%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2859487%22%20slang%3D%22en-US%22%3E%3DIF(ISNA(VLOOKUP(D2%2C'Tab2'!%24H%244%3A%24H%241255%2C1%2CFALSE))%2C%20%22No%22%2C%20%22Yes%22)%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20good%20I%20got%20it%20sorted%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20This%20is%20what%20I%20used%20if%20it%20can%20help%20someone%20else%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi is there a formula to cross reference a name from TAB2 Column H to TAB1 Column C even though they might not be in the same cell, then confirm in TAB1 Column F if there is a match how can I get it to list it as active in Column F? I've used a Countif before but I'm obviously doing something wrong as its not reading how I would like it. Any help appreciated thank you

Porcha_0-1634596905552.png

 

 

 

 

1 Reply
=IF(ISNA(VLOOKUP(D2,'Tab2'!$H$4:$H$1255,1,FALSE)), "No", "Yes")

All good I got it sorted This is what I used if it can help someone else