Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

0 votes
I require a formula that can recognize the distinct codes present in data set 2 from the source table and the second table with the label "x," matching up the appropriate values.

I tried utilizing search, match, index, and google but got no results.
Jan 23, 2023 in Others by Kithuzzz
• 38,020 points
481 views

1 answer to this question.

0 votes

VLOOKUP will work: vlookup

=VLOOKUP(G2,$A$2:$D$11,3,FALSE)

Result:

enter image description here

answered Jan 23, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer
0 votes
2 answers
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,720 points
1,057 views
0 votes
1 answer
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,661 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,901 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
938 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,504 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP