arrays google-sheets google-sheets-formula vlookup array-formulas

Is there any possibilities to change normal vlookup formula to array formula

I have a sheet below, in that I used a formula in "WEEKLY" tab B3 to find the latest price against the code in the "INDIVIDUAL" sheet. I have the formula for my need, but that formula is a normal VLOOKUP. I want to convert the same formula to array formula. so that I can protect that cell to avoid human error. please see the formula in B3, and pls put the array formula in C3. that must give the same result in Col B.

Thank you

here is the sheet

https://docs.google.com/spreadsheets/d/10fxGKhiBwFfv1osdwTI3wu8i3knqmKQKHC8V1ffca5M/edit#gid=107749899

Solution

try:

=ARRAYFORMULA(IFNA(VLOOKUP(A3:A, 
 SORTN(SORT({Individual!C3:C, 
         ROW(Individual!C3:C), 
             Individual!A3:E}, 2, 0), 9^9, 2, 2, 0), 7, 0)))

Remove first element from a $_POST array
Trouble reading numbers from file into array
Dynamically populate a subarray inside of an array declaration
Only print array row data if id is found in a whitelist array
Increment variable name in a loop
Transpose an associative 2d array
how to split each word in a string in a separate list
Array is always empty even when it is expected to have elements
Build a multi-line address string with conditional components
Access only the first row of a 2d array
Doubled elements in result array while scraping HTML content
Loop over an array of unknown depth
How to access keys and values of a multidimensional array
How to union ranges in google spreadsheets
Validate an array as "empty" if it has no elements or if all elements have no length
Generate an array of href strings from all <a> tags in an HTML document using Simple HTML DOM Parser
Extracting JSON response and putting them inside a customize JSON
Best way to filter an objects's properties for data
How to loop over json-encoded data?
Fill array with numbers adding up to a nominated total without exceeding item maximum
Generate an associative 2d array with incremented column values using a flat array as first level keys
Put Values in Multidimensional Array keys
What is the proper way to initialize a fixed length array?
Need help understanding pointer to a type of n elements in C (int (*p)[10])?
Create Pivot table and add additional columns from another dataframe
Algorithm to reverse an array/string only in terms of rotate operations
Group data from lines of a log file by one column and create subarrays from another column
When did iterating on the span of an array become faster than iterating on the array itself
Use values of a flat array as the keys in every row of a 2d array
Function to clear any value by assigning to it a default constructed value of same type