i need help with some formulas for this sheet i need to create
basically what i want the sheet to do is to locate the names in column 1 who have value greater than x in column 2 and then reflect it into a new tablet
now i'm very open minded like if there will have to be several sheets or if this can be done in one sheet
i am aware that this is a bit tricky as i have tried to use VLOOKUP formulas and they work but show one name or they show nothing when i try to get to look for like ">2000" which comes up with N/A
Example:
find the names of everyone who is paid more than 2,000 and put it in a new table
i basically need to put this formula in a new table and it reflects the info from the raw data
OK so here is a made up sample like table
<tbody>
</tbody>
so to recap i need a formula to locate name with salary above 2,000 and put it in a different table like the below outcome
<tbody>
</tbody>
basically what i want the sheet to do is to locate the names in column 1 who have value greater than x in column 2 and then reflect it into a new tablet
now i'm very open minded like if there will have to be several sheets or if this can be done in one sheet
i am aware that this is a bit tricky as i have tried to use VLOOKUP formulas and they work but show one name or they show nothing when i try to get to look for like ">2000" which comes up with N/A
Example:
find the names of everyone who is paid more than 2,000 and put it in a new table
i basically need to put this formula in a new table and it reflects the info from the raw data
OK so here is a made up sample like table
ID | Name | Salary |
23115 | John | 2.100 |
45326 | Jackie | 3.500 |
47839 | Katy | 1,900 |
51946 | Chris | 1,500 |
<tbody>
</tbody>
so to recap i need a formula to locate name with salary above 2,000 and put it in a different table like the below outcome
Highest Paid Employees |
John |
Jackie |
<tbody>
</tbody>