Question regarding VLookup and if it can check two columns of
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.
|