Hello folks,
I having a major headache tryign to get my head around this - no doubt there's a relatively simple solution and I'd be greatfeul if someone could point me in the right direction.
I am trying to retreive information from a table for a specific reference. However, there are more than one entries on that table that I want to retrieve, and my problem is I do not knwo how to set up a vlookup function to retrieve the first record found, the second and so on.
e.g.
Name Item bought cost
Flowers dustpan £1.99
Ali bench £7.99
Ali brush £2.99
Quartey pencils £1.89
What I am trying to do is create a lookup function that not only returns the fact that Ali bought a bench, but also that he bought a brush. I can only get vlookup to work so that it gives me the results of the first match it finds (i.e. the £7.99 bench). Is it possible to use the vlookup function to find the next match (i.e. the £2.99 brush)? Should I be combining the lookup function with a match function or countif function?
Thanks
Bookmarks