Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 !! Last edited by 10ten92 : June 1st 12 at 10:26 PM |
#2
|
|||
|
|||
Quote:
=IFERROR(IF(FIND(F1,A1)0,G1,""),"") |
#3
|
|||
|
|||
Quote:
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 |
#4
|
|||
|
|||
Quote:
So in A it shows as 00123 but in F it shows as 123? |
#5
|
|||
|
|||
Quote:
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. Last edited by 10ten92 : June 4th 12 at 02:14 PM |
#6
|
|||
|
|||
Quote:
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 !! |
#7
|
|||
|
|||
Quote:
Well done! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare columns - weird baffling problem | Excel Programming | |||
Compare Problem | Excel Programming | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Problem with code. (Compare all cells) | Excel Programming | |||
Excel VBA - Help with a loop, compare, delete problem | Excel Programming |