excel compare problem

[10ten92]

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

if you see the attached file

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

I need to put G cell price on B cell

anyone has an idea

Please help me

God bless you !

+-------------------------------------------------------------------
|Filename: Untitled-2.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=397
+-------------------------------------------------------------------

 

[Spencer101]

hi, please understand, my English isn't that good to explain my proble


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,""),""

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[10ten92]

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 contain


number compare to A.

Please help m

+-------------------------------------------------------------------
|Filename: 1.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=398
+-------------------------------------------------------------------

 

[Spencer101]

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 contain


number compare to A.

Please help me

OK, I think I understand what you need now but I have a question. Woul
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[10ten92]

OK, I think I understand what you need now but I have a question. Woul
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

N
Its randomly has 0,00 or no 0

Ty for ur help :

A cell use
Be upc code but some of them excel deleted number 0 when they scaned i

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[10ten92]

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 m
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 !

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

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! :

+-------------------------------------------------------------------
+-------------------------------------------------------------------