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,000 points • 520 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,600 points

Related Questions In Others

0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

answered Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 717 views
0 votes
1 answer

Need to test the live streaming data from kinesis and it will be send to flink application for processing and then output will be flowed from kinesis & stored in Aurora DB.

Hi, @Savitha, Regarding your query, you can go ...READ MORE

answered Dec 11, 2020 in Others by Gitika
 • 65,770 points • 1,398 views
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,600 points • 1,105 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

All you have to do is copy ...READ MORE

answered Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 539 views
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,982 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,990 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 • 976 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,668 views
0 votes
1 answer

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

answered Jan 10, 2023 in Others by narikkadan
 • 63,600 points • 569 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

answered Feb 5, 2023 in Others by narikkadan
 • 63,600 points • 1,196 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.