Forum

Notifications
Clear all

How to Lookup Value

2 Posts
1 Users
0 Reactions
88 Views
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
Topic starter
 

Sir Philip

there is a request for solution of a problem, how can i choose accurate rate of a common number in excel sheet for example column A has number from 1 to 100 and in column B has rates of each number i want rate of 65 through formula by auto fill please guide me, 

 
Posted : 09/07/2020 7:10 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
Topic starter
 

Hi Salim,

Please always start a new topic for each new question.

You can use VLOOKUP to solve this - see attached.

Regards

Phil

 
Posted : 10/07/2020 9:12 am
Share: