V-Lookup???

[HellNoJello]

Ok, this is what I need to figure out. I have two different excel workbooks with the same format. What I need to do is pull data from a column in the second workbook onto the first workbook IF the numbers in a column match.


I need to figure out how to pull data from columns; N, O, P, Q, in workbook 1 into columns and paste it into; Q, R, S, T of workbook 2 if the number in column D is an exact match on both sheets.

Any Ideas?

Thanks!

 

[Andrew Poulsom]

The VLOOKUP function accepts a fourth argument (FALSE) for an exact match.

 

[HellNoJello]

Still lost...

Where can I find a good example of a V-lookup? When I run mine its not working...

 

[Andrew Poulsom]

Would you like to post your non-working formula?

 

[Eiken31]

Try insert a row on top and number your columns. and V-lookup to that reference value instead of hard coding 1, 2, 3, 4...etc...

again, if you have the non-working formula, it will be easier to debug for you..