>
> Dear Mr. Ansari & Anil,
>
I got that sir.. that was in 97 - 2003 format, so that the formula was not
working now i got it sir...
thanks a lot for valueable help
Regards
Jafna
kuwait
>
>
>
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FOR
Then you can use Global Vlookup Formula,provided by *Anil*.
But it will very lengthy in case of 11 sheets.
Syntax is here.
in Excel 2007+ Version
=iferror(*1st sheet vlookup*,iferror(*2ndsheet Vlookup*,iferror(*3rd Sheet
Vlookup*,iferror(*4th Sheet Vlookup*...continue till 11 sheet
Dear Mr. Ansari,
thanks a lot for solution.. but i dont know that the particluar article
place in which sheet. Means.. i cant select sheet from drop down list
manually. Can you please advice how can i find that artilce from that 11
sheet by formula.?
Thanks in advance.
Regards
Jafna
kuwait.
--
Dear Satiqja
Anil Solution is excellent
Apart of this, You can also try below formula with sheet name in List
=VLOOKUP(F10,INDIRECT(TRIM(G6)&"!B:C"),2,0)
see attachment for more clarity.
On Fri, Nov 9, 2012 at 5:18 AM, satiqjaffar satiqjaffar <
satiqjaffar...@gmail.com> wrote:
> Hello brothe
