Search using formula

[Closed]
Report
Posts
1
Registration date
Saturday July 25, 2015
Status
Member
Last seen
July 25, 2015
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
I have around 10 sheets in excel say sheet name as 1 , 2 , 3 .....

I wanted to search a word in specific sheet and get the Number from the next cell using formula

Say for example - I am working in Sheet 5 , i wanted to search closing balance from sheet 4 as how that as opening balance using formula .

and when i use sheet 6 it should automatically take value from sheet 5

Similarly when i create a new sheet say 11 it should pick value from sheet 10

Thanks in Advance
Mahender Lalwani

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Mahender,

I think you are looking for the VLOOKUP formula.

Let's say you are looking for the word "closing balance" on sheet 4 and place the value next to it, in a cell on sheet 5. "closing balance is located somewhere in column A.

Select your cell in sheet 5 and try the following formula there:
=VLOOKUP("closing balance",Sheet4!A:B,2)

Best regards,
Trowa