Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP, columns question / different way? | Excel Discussion (Misc queries) | |||
Question about using VLOOKUP with Data validation | Excel Worksheet Functions | |||
Question about Data-Text to Columns command | Excel Discussion (Misc queries) | |||
Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |