Excel Code Query

The_Hurricane

Hi,

I reviewing some forumlas within a spreadsheet that are used to pull details from an accompanying spreadsheet, however could someone advise exactly what the following formula should be doing please?

I understand it to the point that it is searching within spreadsheet named "Finances" which is stored in Folder_1, however the rest I don't understand.

=VLOOKUP($A$1,'\\Folder_1[Finances.xlsx]Income Value '!$A:$I,9,FALSE).

Thanks in advance.

rmg1

It looks like some of the formula is missing.
If you can post all of it, I'll let you know what it's doing exactly.

In essence, a VLOOKUP formula uses the following sections:-
Lookup_Value - This is the value that needs to be found
Table_Array - This is the range of cells (I usually use entire columns but you can use whatever range you want)
Col_Index_Num - This is how many column to move right before bringing back a value
Range_Lookup (optional) - to find an exact match use FALSE, to find the closest match use TRUE (the first column needs to be sorted ascending for this to work)

For example:-
=VLOOKUP(A1,C:F,4,FALSE)
would look for the value in A1 in column C and then bring back the value in column F in the same row.

However:-
=VLOOKUP(A1,C:F,5,FALSE) would give an error because starting in C and moving right 5 columns would take you to column G which is outside the range of cells you've specified.

The_Hurricane

Hi,

You're correct I missed some of the code, op has now been corrected.

Mobeer

Get the value in cell A1 of the current sheet
Look for this value in column A of sheet "Income Value " of workbook \\Folder_1\Finances.xlsx
Find the first row in which column A is an exact match for the above value (searching downwards from row 1)
From that row, return the value that is 9 columns across the range, which in this case is column I (column A being the 1st column)

If no row is found with an exact match then an error occurs.