More formula

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I have a doubt that :

suppose I have put some data like this

H I
15 1 Rent
16 2 Office maintenance
17 3 Others
18 4 Salary
19 5 TDS
20 6 Freight

Then When I put 1 (Cell adress H15) in Cell A2, The text "Rent "should be shown in Cell B2. Like that if I put 2 (Cell address H16) in Cell A2, tha text "Office maintenance should shown in Cell B2 and so on

How is it possible in Excell?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
in B2 copy paste this formula

=VLOOKUP(A1,$H$15:$I$20,2,FALSE)

copy B2 down

At first the colum B will show only #N/A
but once you enter sme number like 1,2 etc you will get the correct description in the adjacent cell