SOLVED
Home

Lookup and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-724174%22%20slang%3D%22en-US%22%3ELookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724174%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI%20know%20there%20must%20be%20an%20easy%20way%20to%20do%20this%20and%20hope%20you%20guys%20can%20help.%3C%2FP%3E%3CP%3EI%20have%20posted%20a%20picture%20but%20here%20is%20what%20I%20want%20to%20do%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20word%20on%20Column%20B%20is%20equal%20to%20Column%20F%2C%20I%20want%20the%20word%20in%20Column%20G%20to%20appear%20on%20Column%20C.%3C%2FP%3E%3CP%3ESo%2C%20for%20example%2C%20C4%20would%20be%20Apple%2C%20C5%20would%20be%20Beef%2C%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20probably%20a%20very%20simple%20one%20but%20I%20am%20a%20beginner%20and%20would%20appreciate%20your%20help!%3C%2FP%3E%3CP%3EThanks%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121387iF33ECF1ED0F5289D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22IMG_0416.jpg%22%20title%3D%22IMG_0416.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-724174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724522%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367495%22%20target%3D%22_blank%22%3E%40Katie3250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C4%20it%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(INDEX(%24G%3A%24G%2CMATCH(%24B4%2C%24F%3A%24F%2C0))%2C%22no%20such%22)%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20down%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724589%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724589%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367495%22%20target%3D%22_blank%22%3E%40Katie3250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20formula%20in%20C4%2C%20copied%20down%20rows%2C%20will%20also%20return%20your%20desired%20result%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFNA(VLOOKUP(B4%2CF%3AG%2C2%2C0)%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%22Not%20Found%22)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724639%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724639%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724640%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724640%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724649%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367495%22%20target%3D%22_blank%22%3E%40Katie3250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20very%20much%20welcome!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Katie3250
New Contributor

Hi there,

I know there must be an easy way to do this and hope you guys can help.

I have posted a picture but here is what I want to do:

 

If the word on Column B is equal to Column F, I want the word in Column G to appear on Column C.

So, for example, C4 would be Apple, C5 would be Beef, and so on.

 

This is probably a very simple one but I am a beginner and would appreciate your help!

ThanksIMG_0416.jpg

 

5 Replies

@Katie3250 

In C4 it could be

=IFERROR(INDEX($G:$G,MATCH($B4,$F:$F,0)),"no such")

and drag it down

 

Solution

@Katie3250 

This formula in C4, copied down rows, will also return your desired result: 

=IFNA(VLOOKUP(B4,F:G,2,0),

"Not Found")

Thank you so much! @Twifoo 

@Sergei Baklan Thank you very much!!

@Katie3250 

You're very much welcome!

Related Conversations