LinkBack URL
About LinkBacks
Hi everybody
I need some help.
I have a list of items and I want a function which fills in price and such after I enter an item number. I think that vlookup should do the trick, but I don't know how to use it properly.
Any advice?
Thanks in advance.
Hi everybody
I need some help.
I have a list of items and I want a function which fills in price and such after I enter an item number. I think that vlookup should do the trick, but I don't know how to use it properly.
Any advice?
Thanks in advance.
Where is the source data for columns D:J?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I think this is what you want, just copy it across and down...
=INDEX(Folder!B:B,MATCH(TEXT($B5,"0"),Folder!$A:$A,0))
Note that your Item "numbers" in both Folder and Writing, are actually text that just looks like a number. If they were real numbers, then that could be shortened to...
=INDEX(Folder!B:B,MATCH($B5,Folder!$A:$A,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins
thank you for your reply, but unfortunately this doesn't solve my problem. I need the information from multiple spreadsheets and not just one. Your suggestion works with only one spreadsheet as the source. Can you expand it so that it works with multiple spreadsheets? How can the matrix be made (in my example) across 'Folder' and 'Writing utensils'?
And the item numbers are formatted as text, because I need them to allow zeroes before any other figure is entered(000123 or whatever)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks