Step 2: The table array
Now Excel asks you to write the second argument into the VLOOKUP function: the table_array.
This is where you are searching for the lookup value (from step 1, remember?).
This is a bit trickier but don’t worry, it’s over in a minute ⏱️
The table array is a range (group of cells).
This range must contain both the column you’re looking in and the column you want to return something from.
✔️Select or type the range – like you would any other group of cells.
The table array should contain columns A (the lookup column), B, and C.
That means VLOOKUP searches for the order ID in column A and returns the price from either column B or C (you decide which in the next step).
Place a comma to wrap up step 2.
Your VLOOKUP function should look like this by now: