Hi,
I have invoice format in excel. What i want to make is when i select the code of the menu item from dropdown list. the corresponding item should fill the items cell and price cell too.
Example attached.
Hi,
I have invoice format in excel. What i want to make is when i select the code of the menu item from dropdown list. the corresponding item should fill the items cell and price cell too.
Example attached.
Try this...
Do this first...
Unmerge the cells D5:E5.
Entered in D5 and copied across to E5:
=IFERROR(VLOOKUP($C5,Sheet2!$A$2:$C$5,COLUMNS($D5:D5)+1,0),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you very much.
That works fine.
one more question. If i have a long list in drop down menu, i want to search the item by entering the first letter of the item in the keyboard i am looking for. Is this possible?
Possible, but kind of a kludge!
Sort your list like this...
Data Range
A 1 A 2 Albo 3 Allco 4 B 5 Besm 6 Bibs 7 C 8 Clep 9 Clinker 10 D 11 Dopa 12 Drip
Then, when you setup the drop down list goto the Error Alert tab.
Uncheck: Show error alert after invalid data is entered
Now, when using it on the worksheet if you click on the cell and type in a letter like B (don't hit enter) then click the down arrow the list will automatically scroll to the letter B. From there you can scroll to your specific selection.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks