Excel sheet Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2267058%22%20slang%3D%22en-US%22%3EExcel%20sheet%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267058%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20Looking%20for%20some%20help%20with%20the%20correct%20formula%20a%20Excel%20spread%20sheet%2C%20I%20am%20after%20the%20following%20text%20search%20and%20if%20text%20matches%20trasnfer%20value%20from%20Cel%23%20to%20Cel%23%3CBR%20%2F%3EIf%20individual%20cell%20Text%20Data%20from%20column%20A%20matches%20individual%20cell%20text%20data%20from%20column%20H%20then%20value%20or%20number%20shown%20in%20the%20D%20column%20on%20same%20row%20as%20column%20A%20text%20data%20will%20be%20transferred%20to%20matching%20text%20data%20cell%20row%20In%20L%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20cant%20seem%20to%20get%20the%20correct%20formula%20to%20make%20this%20hapen%20for%20me%20any%20help%20would%20be%20appreciated%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20matt%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2267058%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
Occasional Visitor

Hi I am Looking for some help with the correct formula a Excel spread sheet, I am after the following text search and if text matches trasnfer value from Cel# to Cel#
If individual cell Text Data from column A matches individual cell text data from column H then value or number shown in the D column on same row as column A text data will be transferred to matching text data cell row In L column.

 

 I cant seem to get the correct formula to make this hapen for me any help would be appreciated .

 

Cheers matt

1 Reply
You could try this, IN column L, all these on the same row. I did it in row 1.
=IF(A1=H1,D1,"no match")
but if that isn't what you're looking for, then come back with a better description and, if possible, the spreadsheet that you're working with.