basic vlookup with IF? I cant work this out...

**IsabellaLearning** · 12-21-2011, 04:01 AM

HI,

I think its a vlookup but cant get it to work for me with
=VLOOKUP(C2,with!A1:Y11,11)

I would like the "M" column to look at column "C" then match the number in column C with the identical number on a 2nd worksheet ( called "with") number in its column C then return the column M from the 2nd worksheet into column M in the 1st worksheet and the same thing to happen columns M - AA

Or is it a IF value with vlookup? or neither?

Any help on the practice worksheet link attached here would be great
http://www.4shared.com/folder/skjYKtN4/_online.html

Thankyou

Izzy

**somusas** · 12-21-2011, 04:14 AM

vlookup works only when the data is in the first coloumn of the table

change the formula to =VLOOKUP(C2,with!C1:Y11,11)

**Haseeb Avarakkan** · 12-21-2011, 04:30 AM

Hello Izzy,

or use INDEX/MATCH, you can do Left/Right/Vertical/Horizontal Lookups.

M2, copy down & across.

=INDEX(with!$A:$AA,MATCH($C2,with!$C:$C,0),MATCH(M$1,with!$A$1:$AA$1,0))

**IsabellaLearning** · 12-21-2011, 04:49 AM

yeay!!
Thankyou sooooooo much the index/match made my day.

Also thanks for the info on vlookups needing to be in first column only, I did not know that

Izzy