Need a search function

Closed
gulrasool86 Posts 1 Registration date Saturday 10 February 2018 Status Member Last seen 10 February 2018 - 10 Feb 2018 à 03:10
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 10 Feb 2018 à 07:27
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 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
10 Feb 2018 à 07:27
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.