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,010 points • 286 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,700 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,010 points • 404 views
0 votes
2 answers

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.

https://dzone.com/articles/automated-testing-with-junit-and-seleniu ...READ MORE

answered Dec 12, 2020 in Others by anonymous
 • 1,105 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,700 points • 814 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,700 points • 323 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,670 points • 1,641 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,670 points • 1,542 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,670 points • 751 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 • 2,602 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,700 points • 395 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,700 points • 840 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.