Lookup Or Vlookup Formulae 4 whole Workbook??

[deepak8583]

Hi, friends

I need a formulae like Lookup / Vlookup which search whole workbook and returns the value according to reference.

I hve tried alot, Please help me if anyone know, Attached herewith file kindly check & resolve

Many Many thanks in advance

Deepak Sharma
[email protected]

[haripopuri]

In B6:

Please Login or Register  to view this content.

In C6:

Please Login or Register  to view this content.

In D6:

Please Login or Register  to view this content.

[haripopuri]

Damn, saw that you are using Excel 2003 just now. Sorry, IFERROR wouldn't work in 2003 version.

[micope21]

Hi

Notice your file is not excel 2003 file? xlsx file is excel 2007-2013. Please change it in your profile?

Use indirect? It a array formula Press same time Ctrl+Shift+Enter, NOT ENTER?

See the file! Choice is your which one you prefer!!

Regard
micope21

[deepak8583]

Thankyou so much Both Dear @Haripopuri and Dear @micope21, both formulaes are working...

Thanksalot

Deepak Sharma