Compare and Extract VLOOKUP

[N Prakash]

Hi,

I am using following to comapre two columns

=IF(ISERROR(VLOOKUP(B2:B8,I2:I14,1,FALSE)),"Not Available",J2)

When data is matching I want the corresponding data available in J2 column. Will some one help me in correcting the formula or let me know if any MACRO CODE is available to compare two columns and extract date from different column for the matched records.

Regards,
Prakash

 

[tigeravatar]

It looks like you want to look up the value in column B to see if it exists in column I. If it exists, get the matching value from column J. If that's the case, you can use the following:

=IF(B2="","",IF(ISNUMBER(MATCH(B2,$I$2:$I$14,0)),VLOOKUP(B2,$I$2:$J$14,2,FALSE),"Not Available"))

Then copy down for each item in column B

Hope that helps,
~tigervatar

 

[N Prakash]

Dear Friend,

Thank you very much it is working fine.

Regards,
Prakash