If a value is contained in a column...

[mtma]

I was wondering if it is easily possible to achieve the following:

Table1, which is made of the columns A,B & C (Time, ID #, and blank, respectively).
Table2, which is made of the columns A & B (Time and Type, respectively).

Is there a way for me to check to see if Table1[A] is equal to any value in Table2[A] and then for the corresponding 'Type' (Table2[B]) to be displayed in Table1[C] if there is a corresponding value.

Sorry if this is a little vague, let me know if I need to clarify.

[FDibbins]

Hard to be precise without seeing a sample of what you are working with, but take a look at using the vlookup() or index/match functions.

If you still have a problem, upload a small (clean) sample of what you are working with, and what your expected outcome would look like.

[TMS]

Sounds as though you're looking for VLOOKUP.

Regards, TMS

[Mazzaropi]

mtma, Good evening.

Scenario:

Table1
A1:C1

Table2
A1:B10

Search:
Table1 --> C1
=IFERROR(VLOOKUP(A1,Table2!$A$1:$B$10,2,0),"")

Is it what you want?
I hope it helps.

[mtma]

I'm not sure exactly what that does, I'll look into VLOOKUP in a moment. Meanwhile, I have attached a basic spreadsheet scenario.

In this scenario, ideally, if a time in the first table matches a time in the second table AND is type "G", then a "G" is entered into the "Other" column of table 1.
Book1.xlsx

[Mazzaropi]

mtma, Good evening.

Take a look at it:
Book1-ok.xlsx

Is it what you want?
I hope it helps.

[FDibbins]

Mazzaropi, that does not consider that column F needs to contain G, and also, look at C5. That is for 9:30 AM, and E10 is also 9:30 with a G, but the vlookup does not cath that match

Try this, copied down...
=IF(SUMPRODUCT(--(ROUND(Sheet1!$E$2:$E$20,6)=ROUND(Sheet1!$A2,6))*--($F$2:$F$20="G"))=1,"G","")

[mtma]

Thank you both!! Very Helpful!

[FDibbins]

Happy to help and thanks for the feedback

With the suggested vlookup though, check the 9:30 values, it does not catch that

[mtma]

Coooool Thank you again!

[mtma]

I ended up modifying it like this to match my actual sheet:
=IFERROR(VLOOKUP([@Time],HistoryData,6,TRUE),"")

Could anyone tell me where I went wrong?

[TMS]

If you are looking for an exact match, the fourth parameter for the VLOOKUP function should be FALSE, not TRUE.

Regards, TMS

[mtma]

I have tried both, but neither is working.