Getting #value error vlookup formula

[mso3]

Hi friends,

I want to use vlookup formula containing 4 ranges in single cell.
If I use the single formula then it works fine but if I combine it together using ‘or’ function then it gives error.
I used ‘OR’ function for it.
I’m getting error #value.
What’s wrong in the following formula?

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

[Pete_UK]

Try it like this:

=IFERROR(VLOOKUP(B2,ProductIndex!$B$3:$D$1000,2,0),IFERROR(VLOOKUP(B2,ProductIndex!$G$3:$H$1000,2,0),IFERROR(VLOOKUP(B2,ProductIndex!$L$3:$N$1000,2,0),IFERROR(VLOOKUP(B2,ProductIndex!$Q$3:$S$1000,2,0),""))))

Hope this helps.

Pete

[mso3]

Hi Pete ,
Oh! What a silly mistake. Thank you for correction. It's working fine.

Have a nice time.