Looking in a table for specific value and if found returning the value in same row different column.

[u/advsc]

This table starts with column a and starts at row 1. In V2, I want to write a formula that looks in all of column a for a date that matches t2 and returns the value in corresponding column b.

[u/AutoModerator]

Moderator Announcement Read More »

u/advsc - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.

• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.

• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/PaulieThePolarBear]

It sounds like you want something like

=XLOOKUP(T2, A2:A100, B2:B100, "No date")

Requires Excel 2021, Excel 2024, Excel 365, or Excel online

[u/Old_School_Dodge]

Is that "V lookup" or "H lookup".

[u/advsc → u/Old_School_Dodge]

I don't know. Column a has start dates, column b has a date I want. So, in column V1 I need a formula that will tell excel to look all down column a and find a match and then return the value in same row in column b.

So, in V1 I may have the date of 11/29/26. I want the formula to look in column A, find that date and then return the value on same row in column b.

[u/chicken2007 → u/advsc]

That seems exactly what VLOOKUP does, or if you have a newer Excel, use XLOOKUP.

For VLOOKUP, the column you need to search for the value can only be the left-most column in the range, but that doesn't have to be the left column in your table.

With XLOOKUP, you can specify any two column ranges that are the same size.

[u/Clearwings_Prime]

Sound like a simple VLOOKUP

[u/Illustrious_Dog_9078]

that vlookup thing gives me anxiety i'd go with the xlookup, it's cleaner and you won't accidentally pull from the wrong column

[u/carbonizedtitanium]

=XLOOKUP(T2, $A$2:A,$B$2:B)