Lookup cell value in another sheet

[MARKSTRO]

I have a range of numbers in D7:T66, if a value in that range matches a value in column AA8:AA483 I would like to return the value in D4:T4 from the column the column AA match was found.

Which formula should I use, tried many and can't make them work?

Hope I explained it plain enough. Thanks

[tlafferty]

I could use a bit more clarification and perhaps a sample workbook. My guess is that using a combination involving sumproduct and vlookup will get you what you need. Please post a sample book.

[MARKSTRO]

I could use a bit more clarification and perhaps a sample workbook. My guess is that using a combination involving sumproduct and vlookup will get you what you need. Please post a sample book.

I have all the data on Sheet 1. The intent is to keep track of trucks as they are moved among our plants. D7:T66 is the range I would like to feed column AB with the corresponding column heading in row 4 next to the number in AA as it is moved around in the range D7:T66. Columns to the right of AB will be used to keep track of date of movement and then can be sorted as needed.

Thanks for looking at this.

[NBVC]

Column AA is blank???

[MARKSTRO]

I double checked the print area, everything should be there.
The same data is in Sheet 2, I just copied it all to AA to see it all on one screen is all.
I attached an updated sheet, renamed and saved.
Hope it works, thanks,

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and not just ENTER and then copied down.

[MARKSTRO]

Your code works great, thanks.