Complex Lookups
On Wednesday, September 26, 2012 11:46:27 PM UTC-7, MartinSvan wrote:
Hi guys,
I´m trying to create some formulas which best can be described in the
attached example;
Hope someone can give ideas/crack this.
Cheers,
Martin
+-------------------------------------------------------------------+
|Filename: example 2.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=606|
+-------------------------------------------------------------------+
--
MartinSvan
Hi Martin,
For the Item= - Category= Table 2: Input Table.
A2 enter "Item="
A3 enter "Category="
B2 to G2 enter the items, apples, potatoes etc. I added radish in this example.
B3 enter =VLOOKUP(B2,$A$9:$B$14,2,0) and pull across to G3
A9 to A14 list all the items and in B9 to B14 enter if its a fruit or a veg..
Is that something like you wanted?
Regards,
Howard
|