I have a IF issue . I Have a Data Table in Sheet1 with Code and Description data(Text and Numbers) . I want to make a Sheet2 that will accept data grom QR Reader at column Code, check for that data in the DB table (Sheet1) and return data from the next Column in the row where the data was found.




Sheet1
Code Description
bla blablabla
.
.

Sheet2:
Code Description
Read from the QR Scaner If Code (Sheet2)=any Code(Sheet1), return Description from Sheet1

If Code=bla (Read with BarCode Reader) than Description=blablabla (auto filed from Sheet1Description)

Hi
maybe you need the VLOOKUP function

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I;m trying to use all LOOKUP's (V,L) but they doesn't work correctly...

Please post a small sample sheet with what you have and what you need

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I have a sample of what i CAN NOT solve ... Thanks a lot!

Sheet1:
Code Description Number
Code1 Description1 Number1
Code2 ................ ...........
.....
...


Sheet2
Code Description Number

Now:
Exp: Row 4 (First Code B-column = B4)
B4(Code)=Read a Code from BarCode Reader (auto entry)

C4(Description)=(I need to check what data have in Code - B4 (auto entry), search for that data in Code (Columnn-B from Sheet1) and when find the same mach, I want to bring tha data from the same row from (Columnn-D from Sheet1) Description (Exp: If BarCodeReader at B4 read Number 15, then I want C4 to show Description15 (from Sheet1)

D4(Number)=(I need to check what data have in Description - C4, search for that data in Description (Columnn-C) from Sheet1 and when find the same mach, I want to bring tha data from the same row from (Columnn-D) Number (Exp: If Description become Description15 (at C4) than in the D4 I want to have Number15 (from Sheet1 )

Spanec, it would be easier working on a real sheet. You can attach one by editing a post, clicking "Go advanced", click the paperclip and attach your sheet

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for all your help... This can be solved with =LOOKUP(B:B,Sheet1!B:B,Sheet1!C:C)....

BUT, the data need to be Data - Sort ... Ascending and not more then two column that will be searchig ... I did it.

I'm sending the sample!

Attached Files

ExcelFormulaForScanForm.xls (24.5 KB, 13 views)

Is the attached something you can live with?

Attached Files

Copy of ExcelFormulaForScanForm.xls (25.0 KB, 13 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflier,

I'm not an expert for Excel, like you are . And You already Helped me. This solve the problem, I hope , but I will be very happy and thankfull If you can Help me with some other idea. Thanks!