Is this possible using the Vlookup or any other function?

[Delson]

Hi

I have been struggling to find a a quick way of referencing two spreadsheets to find matches on rows. When there is a match i want to bring the value of another cell on the same row across!

We are often trying to match spreadsheets of customers purchasing requirements against out current stock holding. They will send us a list of the manufacturer part numbers they are looking for and how many. I need to reference this against my stock list, find out how many i have and the price.

Is this possible?

[FraserKitchell]

This sounds very doable. Can you post a small example? Thanks,

Fraser

[Delson]

I have almost cracked it by using parts of formulas i found on other threads. I am using the following formula

=IF(ISERROR(VLOOKUP(A21,Sheet2!$I$2:Sheet2!$J$6498 ,2,0)),"Not in List",VLOOKUP(A21,Sheet2!$I$2:Sheet2!$J$6498,2,0))

However i also want to display the values in col L, how would i change this formula to show those values?

[FraserKitchell]

I'm still not sure what exactly you are trying to do...displace column L in a seperate cell or in the same cell. Since these are both text values, you might be looking for a =CONCATENATE( function, which will splice text from two cells together.

[ConneXionLost]

Hi Delson,

Try this:

=IF(ISNA(MATCH(A21,Sheet2!$I$2:Sheet2!$I$6498,0)),"Not in List",VLOOKUP(A21,Sheet2!$I$2:Sheet2!$L$6498,4,0))

Cheers,