V Lookup or Macro for finding matching data

[rhudgins]

In the spreadsheet I want my lookup value to be in column D (ex. ALK22010) then in the multiple data sets( ALK Equity, AAI Equity ect.) find a matching value starting with Column Q then X then AE ect. If the value can be found in one of the data sets then I would like to return the value from the "Day" column in the data set. For all matches I would like the data from the "Day" column returned to column J. I attempted to do a vlookup in column I for the first two data sets and the formula works but could not get the Vlookup to work when I tried to include a 3rd, 4th, 5th ect.. data set into the formula. If anyone knows how to write a long Vlookup statement that would be helpful or can write a macro to do this would be great! Thanks

[ConneXionLost]

Since your data sets all use identical columns and each row contains unique values, you could simplify this problem by rearranging the data sets into one table. This would eliminate the need for multiple VLOOKUPs.

Cheers,

[protonLeah]

This is a double post (rule ?). You must be more patient.. I have posted a potential sol'n in the other thread.