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 |
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 |
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 |
All times are GMT +1. The time now is 12:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com