is anything wrong with this function

=VLOOKUP(AC6,Leases!K:L,12,FALSE)

AC6 is the unique number relative to both tables.

K is the column of the unique number

L is the Number I am trying to find

12 is = to L in the alphabet.

????????

Just looking at it, there's nothing wrong with it. Putting it in your spreeadsheet example from your other example it worked fine.

What error are you getting?

Smitty

If you change the Function to this

=VLOOKUP(AC6,Leases!K:L,2,FALSE)

this should work for you
I just replaced 12 with 2

Although L is the 12 letter of the alphabet you are only looking up 2
Columns K and L so the VLOOKUP you suggested was trying to find the
12th Column in the range K:L which dosen't Exist hence #REF! is returned.

Hope this helps

David

Is it possible to look up two seperate columns while using a v lookup?

Ex: The data is in Coloumn A and D.

I think not.

You might have to do nested INDEX/MATCH functions to accomplish this.

I like sumproduct - it's easier to understand than the index/match

HTH
texasalynn