I want to retrieve value from multiple sheets of same workbook

[Gokuneo]

Hello Everybody,..

I have a situation where I request your support,

My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4)

sheet2(Delhi Zone): It contains serial_no, start_price, new_price as
1 669 1234
2 639 7894
3 695 9654
4 586 9875
and so on till 33 enteries(Table is already generated)

sheet3(UP Zone): It contains serial_no, start_price, new_price as
1 568 2134
2 539 9594
3 582 3554
4 594 4375
and so on till 24 enteries(Table is already generated)

sheet4(MP Zone): It contains serial_no, start_price, new_price as
1 138 2314
2 964 6952
3 753 5638
4 395 7854
and so on till 19 enteries(Table is already generated)

sheet1(Master):It asks for user input and requirement is result

Q1: Search for new_price from the workbook old price is known. Ex. if old_price is 753, what is the new_price (Need to enter in sheet1-Master and search from sheet4)

Q2: Find lookup value of new_price of serial_no(3- taken as input) of sheet3(Taken as input), from sheet1 itself

If same can be achieved by any formulas, please assist. Thanks in advance

[alansidman]

Will the old price ever appear on more than one sheet?

Please rephrase Q2 as your explanation of what you are after is not clear. What would be an example of the new price to look up and the expected result.

[Gokuneo]

No, old_price will be unique for each sheet, but entered value can be repeated in sheet2, or sheet3, or sheet4, so user input from either of sheet (not Master), needs also to be taken as input.

As for as the second query goes, user needs to find new_price of item having serial_no (3) of sheet3. So if user enters items serialno(3)- list shown in master sheet, also enters reference sheet number(sheet3 in this case), ----- 5638 should appear(new_price)

Hope, I could make my question bit more clear,... Thanks