Ask a question Report

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 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen

- Feb 10, 2018 at 07:27 AM

Excel Ask a question Report

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.

Your reply

Reply to this topic

1 reply

Report Respond to Mazzaropi

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 10, 2018 at 07:27 AM

Thank you

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.

Your reply

Reply to this topic

Ask a question