Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP help
Hi,
How do I setup VLOOKUP so that it looks up the 1st three letter of the cell in a column, then put other information in other column on the corresponding row. Data sample: Worksheet 1 Worksheet 2 A A B C (column) 1 1AB-005 1AB 114 A 2 2ER-515 4BR 115 B 3 4BR-006 2ER 116 C VLOOKUP(A1, worksheet2!A1:C3, 2, FALSE) Lookup worksheet 1 2ER####, if the frist 3 letter match column A in worksheet 2, then return the corresponding row that matches in column B = 116. Thanks for any tips |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP help
Try this:
=VLOOKUP(LEFT(A1,3),worksheet2!A1:C3,2,FALSE) HTH, Elkar "Cam" wrote: Hi, How do I setup VLOOKUP so that it looks up the 1st three letter of the cell in a column, then put other information in other column on the corresponding row. Data sample: Worksheet 1 Worksheet 2 A A B C (column) 1 1AB-005 1AB 114 A 2 2ER-515 4BR 115 B 3 4BR-006 2ER 116 C VLOOKUP(A1, worksheet2!A1:C3, 2, FALSE) Lookup worksheet 1 2ER####, if the frist 3 letter match column A in worksheet 2, then return the corresponding row that matches in column B = 116. Thanks for any tips |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP help
one easy way is to use:
vlookup(left(A1,3) this would look up the left three characters this assumes that the left three characters would be unique "Cam" wrote: Hi, How do I setup VLOOKUP so that it looks up the 1st three letter of the cell in a column, then put other information in other column on the corresponding row. Data sample: Worksheet 1 Worksheet 2 A A B C (column) 1 1AB-005 1AB 114 A 2 2ER-515 4BR 115 B 3 4BR-006 2ER 116 C VLOOKUP(A1, worksheet2!A1:C3, 2, FALSE) Lookup worksheet 1 2ER####, if the frist 3 letter match column A in worksheet 2, then return the corresponding row that matches in column B = 116. Thanks for any tips |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |