Need a search function

[Closed]
Report
Posts
1
Registration date
Saturday February 10, 2018
Status
Member
Last seen
February 10, 2018
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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.

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.