vlookup(A1,table!A:Z,2,0) vlookup(A1,table2,2,0) vlookup(A1,table!$A$1:$Z$10,2,0)
L larfy Sep 11, 2007 #1 vlookup(A1,table!A:Z,2,0) vlookup(A1,table2,2,0) vlookup(A1,table!$A$1:$Z$10,2,0)
G Gary''s Student Sep 11, 2007 #2 The first and thrird refer to tables on a tab named "table" In the first the table is the full column height In the third the table is limited to 10 rows The second refers to a table named "table2", probably a Named Range.
The first and thrird refer to tables on a tab named "table" In the first the table is the full column height In the third the table is limited to 10 rows The second refers to a table named "table2", probably a Named Range.
