need help with a VLOOKUP formula

[AmrAndy93]

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

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Salary [/TD]
[/TR]
[TR]
[TD]23115[/TD]
[TD]John[/TD]
[TD]2.100[/TD]
[/TR]
[TR]
[TD]45326[/TD]
[TD]Jackie[/TD]
[TD]3.500[/TD]
[/TR]
[TR]
[TD]47839[/TD]
[TD]Katy[/TD]
[TD]1,900[/TD]
[/TR]
[TR]
[TD]51946[/TD]
[TD]Chris[/TD]
[TD]1,500[/TD]
[/TR]
</tbody>[/TABLE]








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

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]Highest Paid Employees[/TD]
[/TR]
[TR]
[TD]John [/TD]
[/TR]
[TR]
[TD]Jackie [/TD]
[/TR]
</tbody>[/TABLE]

 

[NBVC]

If you have 2007, you don't need to try the LOOKUP() version... it will the same.

Perhaps you need to check if you have autocalculation on? Go to Formulas tab, then in Calculation Options, check that Automatic is selected.

If you drag the formula down, it should give you the subsequent matches.

 

[AmrAndy93]

ok just tried this formula and it came up with error saying too few arguments and then it highlighted the table array segment

now the one that weazal modified worked but only came up with one name which is in B2 cell and it wouldn't allow me to do a drag down for the rule

 

[AmrAndy93]

If you have 2007, you don't need to try the LOOKUP() version... it will the same.

Perhaps you need to check if you have autocalculation on? Go to Formulas tab, then in Calculation Options, check that Automatic is selected.

If you drag the formula down, it should give you the subsequent matches.

i just tried this and it is working perfectly!! you are a star

thank you guys so much for the help and i'm sure this won't be the last time we cross paths :D