In my excel sheet I have a part number (47-6) in one column and there are several workcenters assocaited with this part (Layup/Machining/NDT etc) in another column and the dates that these parts are to begin. My question, how can I have my formula to retireve the date by refrencing the part and the workcenter?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vlookup with multiple fields I need to refrence?
- Thread starter Toddow
- Start date
cfree36
Board Regular
- Joined
- Oct 5, 2005
- Messages
- 175
Yes.
You can use concatinate in your lookup formula
Insert a column to the left of your data table (A). In that column use this formula: =B1&C1 (Part Number & Work Center)
Name your range A1:D (whatever)
You can use concatinate in your lookup formula
=vlookup(A1&B1,range,4,0)
A1 being the part number
B1 Being the Workcenter
You can use concatinate in your lookup formula
Insert a column to the left of your data table (A). In that column use this formula: =B1&C1 (Part Number & Work Center)
Name your range A1:D (whatever)
You can use concatinate in your lookup formula
=vlookup(A1&B1,range,4,0)
A1 being the part number
B1 Being the Workcenter
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Toddow said:
Try to post 5 rows from the relevant columns.
Upvote
0
Similar threads
- Question
