Can someone recommend if VBA is the way to go or if using this Dropdown list to look up numbers is better? I am a newbie so don't want anything so complicated that I will not understand. It's my first time using a combo box.
I created this simple lookup, but it's out of whack. I can not understand why the formula is in D14 and brought over the entire column from Sheet1. It will not allow me to move it back to B4 and gave me an ARRAY error. Did I write it incorrectly? I just want to search from rows 2-15, not insert it all. So this should be a simple exercise for pros, but I am a beginner, so I am stumped on how to fix this.
So I tried to use this formula instead, but it returns an #N/A error.
So in short,
Enter number or select from dropdown
Returns the Licence from Sheet 1.
Thank you for your help.
Sheet1
Sheet2
I created this simple lookup, but it's out of whack. I can not understand why the formula is in D14 and brought over the entire column from Sheet1. It will not allow me to move it back to B4 and gave me an ARRAY error. Did I write it incorrectly? I just want to search from rows 2-15, not insert it all. So this should be a simple exercise for pros, but I am a beginner, so I am stumped on how to fix this.
Excel Formula:
=IF(ISNUMBER(SEARCH($B$4,Sheet1!B2:B15)),Sheet1!A2:A15,"")
So I tried to use this formula instead, but it returns an #N/A error.
Excel Formula:
=VLOOKUP(B4,Sheet1!A2:B171,2,0)
So in short,
Enter number or select from dropdown
Returns the Licence from Sheet 1.
Thank you for your help.
Sheet1
Licence | No. |
123456 | 009 |
123457 | 010 |
123458 | 011 |
123459 | 012 |
123460 | 013 |
123461 | 014 |
123462 | 015 |
123463 | 016 |
123464 | 017 |
Sheet2
Sample Lookup.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Enter No. | ||||
2 | |||||
3 | |||||
4 | 010 | ||||
5 | |||||
6 | |||||
7 | Your Licence is: | ||||
8 | #N/A | ||||
9 | |||||
10 | |||||
Sheet2 |