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.

=INDEX(C2:C500,MATCH(1,(A2:A500="Make 1")*(B2:B500="Model1"),0))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Smoke" wrote in message
...
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.

Hi - and thanks for the quick reply.

I've encountered a slight problem with that as it returns a 0 value - not
sure why it's doing that. There's over 18000 different entries also, so doing
that would result in me doing it 18000 times entering the Make1/Model1 each
time. Can I make it refer to what's actually in sheet2 in column A and B
rather than entering the values?

Thanks again.


"Peo Sjoblom" wrote:

=INDEX(C2:C500,MATCH(1,(A2:A500="Make 1")*(B2:B500="Model1"),0))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Smoke" wrote in message
...
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.