View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smoke Smoke is offline
external usenet poster
 
Posts: 2
Default 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.