Microsoft Office Forums - View Single Post - [Solved] IF Check Field and return content (Small DB-table)

Thread: [Solved] IF Check Field and return content (Small DB-table)

View Single Post

Old

01-11-2012, 06:40 AM

Spanec

Spanec is offline

Spanec uses Windows XP

Windows XP Spanec uses Office 2003

Spanec uses Office 2003

Office 2003

Novice

The original poster

Join Date: Jan 2012

Posts: 7

Spanec is on a distinguished road

Default

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, 15 views)

Reply With Quote