Need a search function

gulrasool86 1 Posts Saturday February 10, 2018Registration date February 10, 2018 Last seen - Feb 10, 2018 at 03:10 AM - Latest reply: Mazzaropi 1745 Posts Monday August 16, 2010Registration dateContributorStatus February 20, 2018 Last seen
- Feb 10, 2018 at 07:27 AM
i have BPS in cell A1 and the pay Cell A2 on sheet 1
and on sheet two i have a data in this range g3:aj23

now my question is for example
my A1 cell contain 7 which is BPS
and A2 contains 23260 which is pay of the employee

in A3 i want an excel to go in sheet 2 and search in the whole sheet wheter in BPS 7 row if A2<= any value in return i want the value next to this.

help please.
See more 

1 reply

Reply to this topic
Mazzaropi 1745 Posts Monday August 16, 2010Registration dateContributorStatus February 20, 2018 Last seen - Feb 10, 2018 at 07:27 AM
0
Helpful
gulrasool86, Good morning.

What's BPS ?

Please, to easier our answer to you save you example file at a free site www.sendspace.com or other and put a link to download here.

Make sure you put data you have and a solution you expect.
Respond to Mazzaropi