excel compare problem
 

hi, please understand, my English isn't that good to explain my problem :)

if you see the attached file


I need to match A and F cell , if F Cell contains number from A

I need to put G cell price on B cell.

anyone has an idea?


Please help me.

God bless you !!

Try this formula in cell B1 then copy down.

=IFERROR(IF(FIND(F1,A1)0,G1,""),"")

really thank you for your answer :)

but my question was bad, here is the right question.

please check an attached file.

I need to match A - F cell and get a number from G cell if F contains

number compare to A.

Please help me

OK, I think I understand what you need now but I have a question. Would the number in A always have two additional numbers at the start?

So in A it shows as 00123 but in F it shows as 123?

No
Its randomly has 0,00 or no 0

Ty for ur help :)

A cell used be upc code but some of them, excel deleted number 0 when my scanner read the numbers becuase of cell type wasn't text type.

I got the answer by myslef :)

If F cell is text format

=VLOOKUP(TEXT(VALUE(A2),"0"),F:G,2,0)



If F cell is number format

=VLOOKUP(VALUE(A2),F:G,2,0)


TY !!

Well done! :)