Hello! Say I have got two excel-tabs: One containing persons (customers) and their phone number, in two different columns. This tab is called "customers". Another tab is called "orders". In the tab "orders", I've created a scroll list, where you can click and choose a person in the "customers"-tab. Now my problem is this: Is it possible to make the customers phone number appear in the cell next to the cell with the list function automatically in the "orders" tab??
Last edited by aleks6561; 08-14-2010 at 08:33 AM.
can you quickly attach a simplified version of your file. thanks
If I helped, Don't forget to add to my reputation (click on the little scale)
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
when you reply to this post, Select "Go Advanced" then scrolled down you'll see the option to attach a file
Sure! See my attached file example. I|ve used the names as I described in the text above!
I used a vlookup, let me know if you need more explanations
This is wonderful, but can u plz tell me in the VLOOKUP Formula, why did u choose [rang_lookup] = 0 instead of some other values?
One Important thing to remember is that let's say you add more name and numbers to Customers tabs, DON'T FORGET TO CHANGE THE RANGE OF THE TABLE_ARRAY IN THE VLOOKUP, in the case you add more names/nbers above the current set range A2:B32 in the Customers tab
WOW! That was fast! I got it working now, thank you!
where can i mark it as solved?
edit your first post and in the suffix drop down nxt to your title, mark solved, also don't forget to add to my reputation
glad it worked
The Range Lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.
for instance the numerical value for TRUE/FALSE in excel in 1 and 0 respectively. So I specified zero because I wanted the vlookup to find AN EXACT MATCH to the value I was looking for, if I'd have specified 1; it would have looked for an exact or approximate match to be returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
Bottom Line, I always put zero in the range lookup; because I always want to find an exact match...for me it's mechanical...Always ZERO
hope it helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks