To Compare a value in a column

msk - Jul 20, 2009 at 04:01 AM
 Trowa - Jul 21, 2009 at 07:30 AM
i have requirement like this
I have two work sheets in a work book
I have to compare a cell value (in second sheet) with a cell value in a column of first work sheet and need to find the row number
i have to get the cell value of the corresponding row number (in different column) in first sheet
i have to copy this and paste the same in other cell (in different column) of second sheet
please provide the solution if anyone knows


2 replies

Hi msk,

Try the V.Lookup function.

If you can't figure it out, let me know how both your sheets look like.

Best regards,
i tried with v look up
but getting the error
sample1.xls, sample2.xls
just i need to take the ref of sample2.xls in sample1.xls
i need to compare and paste a corresponding value in sample1.xls
please let me know the exaxt function which works without errors.

Now you have confused me Msk.
First you post that you have 2 sheets in 1 workbook and now you are saying that you have 2 excel files.

Can you let me know if you are using 1 or 2 workbook(s) and again give me an example of how your sheets look like or else it is impossible to create a function for you.

You can also upload your file (without any personal info) using this link:

Best regards,