Excel ... Dynamic data validation

Microsoft Excel 2007
August 2, 2011 at 07:08:53
Specs: Windows 7
Hey Every One,

Am Doing a Sheet using dynamic data validation, also using the offset function

actually the part of the data validation list worked with me, and I made a cell which contain the Mach function to mach the id_no with the order_Id and its giving me the mach wich i need

but my problem is than i want to retrive the data from the table without using vlookup function, i need the cells to be empty cause am using navigation buttons too.

actually my sheet has buttons such as first record and next record
my need is
when i choose the id no the match will retrive the record numer,

i dont know if you understand me actually , i dont know how to explain

can i attach my sheet here, please, i want to attach it as sheet please


See More: Excel ... Dynamic data validation

August 2, 2011 at 07:29:02
Please let me explain more

actuaaly my work sheet has the following:

1. Navigation Buttons
buttons to view the first, previous, next or last record in the database.

2.((( Select a Specific Record and my problem is here ???????? )))
Select an Order ID from the drop down list in cell L3, to see that order
In cell M3, the formula calculates the record number for the selected Order ID.

I used dynamic named ranges

please help me, I hope that i have explain my problem more better

Report •
Related Solutions

Ask Question