P
Pam1288
Is there a function similar to VLOOKUP, that will only find exact matches
between spreadsheets?
between spreadsheets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bpeltzer
VLOOKUP accepts an optional fourth argument. Without it, you get a 'range
lookup.' If you supply FALSE as the fourth argument, vlookup looks for an
exact match: =vlookup(value, table, column#, FALSE).
lookup.' If you supply FALSE as the fourth argument, vlookup looks for an
exact match: =vlookup(value, table, column#, FALSE).
P
Pam1288
Thanks, for you help. I'm still having a problem with this function. It
might be clearer if I define my problem more because I dont understand how to
structure the argument properly.
I have two spreadsheets that contain information on a series of item
numbers, however, both sheets do not contain all items. The item number is
in the first column of both spreadsheets. What I want the function to do is
search spreadsheet A, for the item number listed in the first column of
spreadsheet B, if it finds a match I want it to return the value of the 5th
column in Sheet A to a field in spreadsheet B.
might be clearer if I define my problem more because I dont understand how to
structure the argument properly.
I have two spreadsheets that contain information on a series of item
numbers, however, both sheets do not contain all items. The item number is
in the first column of both spreadsheets. What I want the function to do is
search spreadsheet A, for the item number listed in the first column of
spreadsheet B, if it finds a match I want it to return the value of the 5th
column in Sheet A to a field in spreadsheet B.
B
bpeltzer
You didn't say where you want the data returned. For the purposes of the
example, let's suppose the item number of interest is in SheetB cell A2, and
you want the data from SheetA returned to cell B2. Then in B2:
=vlookup(A2,'Sheet A'!$A$1:$E$4000,5,false) (replace the 4000 with the final
row of your data in sheet A, or just use $A:$E to search the entire column).
--Bruce
example, let's suppose the item number of interest is in SheetB cell A2, and
you want the data from SheetA returned to cell B2. Then in B2:
=vlookup(A2,'Sheet A'!$A$1:$E$4000,5,false) (replace the 4000 with the final
row of your data in sheet A, or just use $A:$E to search the entire column).
--Bruce