Need a search function

Closed
gulrasool86 Posts 1 Registration date Saturday February 10, 2018 Status Member Last seen February 10, 2018 - Updated on Feb 10, 2018 at 05:43 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - 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.
Related:

1 reply

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Feb 10, 2018 at 07:27 AM
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.
0