Link to home
Start Free TrialLog in
Avatar of stressedout2004
stressedout2004

asked on

Search, Match and return a value

Looking at the picture PIC1
I want to populate column H with the data returned form Column A.

For the server names in Column G search for the names in the corresponding Column F, if found,  return the data Column A in  Column H.

Here is what I want to achieve
PIC 2 represents the format i want to achieve.   I don't know excel at all for awareness.
PIC2.JPG
PIC.JPG
Sample.xlsx
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Can you upload a sample file rather than screenshots?
Hi stressedout2004, Just wanted to confirm that the Sample.xlsx file is a sample that has your example input and output?
it looks like it just has the sample input correct?
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial