I would like some help with an an Excel formula as I am unable to infer if I need to use
index match for this.
I have 3 columns of data but how can I create a X, Y, Z mesh. How can I create a formula, so that, in my table “This is what I have”, reference the number 1 in Column X and Apple in Column Y located in “Table 1” and return the 1000 located in Column Z?
I would like the formula to output out the numbers 2000 and 3000 as well.
Basically, what formula can I use to get the numbers in red. The last table is how I would like the output to be shown.