Multiple vlookups

[Jietoh]

Hello All!

I've been asked to write a formula for google sheets that will combine information from 6 different sheets into one spot on a 7th sheet. I did accomplish this using concatenate, but I'd like the formula to authenticate itself the way that vlookup does, so that if anyone of the 20 or so users changes the order of the data on any sheet (moves, adds, or deletes a row) that the data remains consistent. However, I'm having a hard time getting a multiple vlookup formula to work properly.

What I've tried:

Please Login or Register  to view this content.

Any ideas on what is wrong with the formula? Is vlookup even the best way to go given this situation?

Thanks!

[rcm]

Please Login or Register  to view this content.

this will make the formula work.

[Jietoh]

Sorry rcm, but that doesn't appear to be working either. It keeps returning the false value no matter if the cell is blank or not.

[Jietoh]

Well after a lot of tweaking and experimenting, I finally got a working formula. It is one that I tried before, but must have done something wrong since I then moved on to more and more complicated attempts.

Please Login or Register  to view this content.