VLookup?

[richblake74]

Hello all.
on Sheet LOG i have a column (AD) with Peoples names and this would be the column where

I want another Sheet "Summaries" that has a Table of A1 to D53, Col A has the peoples names (on Summaries sheet), Col B has number of flights and col C has Flight times.


I would like the tables in Summaries to match the Names from COL A in Summaries sheet with the Col AD in the LOG sheet, and insert in col B in Summaries sheet all the flights that I do with a certain person from LOG sheet col M.
Does that make sense?

(I cant seem to be able to post a picture of the problem)

 

[Special-K99]

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[Special-K99]

This doesnt make sense what you described.

1. "on Sheet LOG i have a column (AD) with Peoples names"
OK so far.

2. "another Sheet "Summaries" that has a Table of A1 to D53, Col A has the peoples names (on Summaries sheet), Col B has number of flights and col C has Flight times."
This is presumably all on the Summaries sheet since you haven't said otherwise? OK again.


"I would like the tables in Summaries to match the Names from COL A in Summaries sheet with the Col AD in the LOG sheet, and insert in col B in Summaries sheet all the flights that I do with a certain person from LOG sheet col M."

Insert in Column B in Summaries? But Column B in Summaires already has number of flights as you stated in 2. So you would be overwriting the data in Summaries column B.
Formulas cannot insert columns. You would need VBA for that.

What you've asked for is overwriting the existing flight data but I don't think that's what you really want.
It would be better if you stated what sheet you are expecting the output (flights and flight times) to appear on? Presumably the LOG file but you havent stated that at all.

SEPARATE QUESTION: In the list of names on both the LOG sheet and the Summaries sheet, are ANY of the names repeated? That would cause problems.