If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question regarding VLookup and if it can check two columns of data
Hi,
My experience with any excel formulas is very limited and I was just wondering if someone could provide me with a formula / and or help with my current problem. I have two sheets in the same workbook and would like to return data from column 3 in sheet 1 to column 3 in sheet 2. However, i don't know if Vlookup can check two columns of data (text) in sheet 1 with two columns in sheet 2. Example below: (Imagine | as the divider between columns) Sheet 1: A | B | C Make 1 | Model1 | 2000 Make 2 | Model1 | 1000 / 1002 Make 3 | Model3 | 1003 Sheet2: A | B | C Make 7 | Model5 | N/A Make 1 | Model1 | 2000 Make 3 | Model3 | 1003 So as you can see above, I'd like it to check Make AND Model in sheet two with sheet one and return the value in column C in sheet 1 to column C in sheet 2. Any help with this would be great. Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|