Search using formula

Closed
MahenderLalwani Posts 1 Registration date Saturday July 25, 2015 Status Member Last seen July 25, 2015 - Jul 25, 2015 at 12:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 27, 2015 at 11:30 AM
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 27, 2015 at 11:30 AM
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