Hello Hui,
thanks alot for your prompt respond, i tried your formula's but i think it give the first value of the chosen item for all of the rows that hold the formula's.
what am trying to do is the following:
let's assume that the table 1 is a purchasing statement for the 3 items, and each...
Hello,
I have a table that contain different results for different items, i would like to use something like vlookup formula to show the results related to one of the items (as shown below), the problem if the items are not sorted based on the item name then i'll have gaps between the rows...