lookup value in many workbooks also lookup if certain column header match

[jitendra6872]

Hi ,

I am posting a file in which column b values given I need a macro which will check column A value then open column A workbook then take respective column b value and lookup in the workbook column a if value found take value complete row and put in my file where i run this macro ,like this In short
check column A then open that file from folder or in same folder and search respective b column value.so on

is it possible

 

[Luke M]

Hi,

It would help if you could provide more description on what you want, as well as more examples. While you attached 3 files, I don't see any current links between the files. I'm also not sure how they are supposed to interact with each other. Is column A of "first" the file name, or the value we are searching for. Or both?
It also sounds like you are trying to create a summary workbook. If so, I'd suggest checking on Ron's Workbook Merging examples here:
http://www.rondebruin.nl/win/section3.htm

He has several wonderful examples/templates, as well as a few add-ins that make creating summary sheets/books a breeze.

 

[jitendra6872]

Hi luke,
Thanks for suggest.
Yes column A "first" is file name column b value which will look in first file and when first file found match of column b value in it get data from thw file.