Vlook up function

GAUTAM SINGH

New Member
Joined
Dec 24, 2016
Messages
31
I HAVE TABLE WITH FOLLOWING FORMAT
TOTAL DAYS OF WORKINGCLERK
(AMOUNT)
MANAGER
(AMOUNT)

AUDITOR
(AMOUNT)
ACCOUNTANT
(AMOUNT)
9 258825800925
124589269001025

<tbody>
</tbody>
IN THE END OF THE MONTH I WANT TO PAY THEM AFTER FULFILLING THE ABOVE TWO CRITERIA I.E. TOTAL DAYS OF WORKING AND THE POST THEY HOLD BY RETURNING THE VALUE THROUGH THIS TABLE.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Hello, can you explain it more detailed, and do you have this Table in excel spreadsheet, if you do can you share it?
 
Last edited by a moderator:
Upvote 0
QSSEPOY AXSEPOY BCDFYSEPOY GHEZNAIK AXNAIK BCDFYNAIK GHEZHAVILDAR AXHAVILDAR BCDFYHAVILDAR GHEZ
150000463738833743463738833743463738833743
150600473039613818473039613818473039613818
160000482240383893482240383893482240383893
160600491541163967491541163967491541163967
170000500841944042500841944042500841944042
170600510042714117510042714117510042714117
180000519343494192519343504192519343504192
180600528644274267528644334267528644334267
190000537945044342537945174342537945174342
190600547145824417547146004417547146004417
200000556446604491556446844491556446844491
200600556446604491556447684517559047684517
210000556446604491564748514597569548514597
210600556446604491574449354676580049354676
220000556446604491584150194755590650194755
220600556446604491584150194755601150274772
230000556446604491584150194755611751154856
230600556446604491584150194755622252034940
240000556446604491584150194755632852915023

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

PART OF THE TABLE IS GIVEN ABOVE
 
Upvote 0
I am having a huge data comprises of qualification and rank of the person. I want their entitlement is drawn from the above table after fulfilling the criteria of qs and rank. For example person with rank naik az and qs 206000(yymmdd) should get 5564/-
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top