Having problem in finding a data

[Nishant79]

Hi there i have a number to find from the data and return me the name of that product from the number but the problem is that number is in C column and the data name for the number is in A column so then how to i find the data because using vlookup gives me error because the data is in last Column and i want the data which is in the column before that.

Please help me

E.g:
A B C
Maggi 58 30%

So from the above eg as you can see i want to find the data in A column (Maggi) by looking up the value in C column ie (30%).

 

[GlennUK]

Look at this:

Excel Workbook
	A	B	C	D	E	F
1	A	B	C			formula
2	Freddi	45	25%		30%	Maggi
3	Maggi	58	30%
4	Kenni	65	45%
5	Bennu	76	66%
Sheet2

 

[hiker95]

Nishant79,

Excel Workbook
	A	B	C	D	E	F
1	Nishant79	79	20%		30%	Maggi
2	hiker95	95	40%
3	Maggi	58	30%
4
Sheet1

 

[Nishant79]

Hey thanks worked perfectly for me Glenn and thanks hiker too for the help ....sorry hiker i have to say this glenns process was easy to understand yours was a little complicated though .Still would thank both of you for the help.