Vlookup multiple sheets

[Clueless401]

Hello friends,

How can i make this formula lookup qty from not only the inventory sheet but also the Other sheet? PLEASE HELP! :/

 

[Joe4]

Just do two separate VLOOKUP formulas added together with the + sign, i.e.
=VLOOKUP(...) + VLOOKUP(...)

 

[Clueless401]

Just do two separate VLOOKUP formulas added together with the + sign, i.e.
=VLOOKUP(...) + VLOOKUP(...)

Not working is it wrong?

 

[Joe4]

OK, so you know that your original formula was working, so that first VLOOKUP should be OK.
Focus on your second VLOOKUP (on the "OTHER" sheet). Try to write that one by itself. Once you get it working, then you can add it to the first one.

Note that if it is possible that one of the sheets might not have a match, you need to account for that (as that will cause the VLOOKUP to return the #N/A error).
You can do that with this structure:

=IFERROR(VLOOKUP(...),0) + IFERROR(VLOOKUP(...),0)

which will return a 0 if it does not find a match (instead of an error).

Note that I am counting on you filling in the details for the VLOOKUP where I show the ...
The point is to just show you the formula structures.
Since you were able to create the first VLOOKUP successfully, I trust that you know how to set them up.

 

[Clueless401]

OK, so you know that your original formula was working, so that first VLOOKUP should be OK.
Focus on your second VLOOKUP (on the "OTHER" sheet). Try to write that one by itself. Once you get it working, then you can add it to the first one.

Note that if it is possible that one of the sheets might not have a match, you need to account for that (as that will cause the VLOOKUP to return the #N/A error).
You can do that with this structure:

=IFERROR(VLOOKUP(...),0) + IFERROR(VLOOKUP(...),0)

which will return a 0 if it does not find a match (instead of an error).

Note that I am counting on you filling in the details for the VLOOKUP where I show the ...
The point is to just show you the formula structures.
Since you were able to create the first VLOOKUP successfully, I trust that you know how to set them up.

THIS IS WHAT WORK, THANK YOU FOR HELPING

 

[Joe4]

Note that will only look up one or the other.
If the possibility exists that they appear on both sheets, it will NOT add them together.
You would need to add the two VLOOKUPs like I showed you, instead of imbedding them in an IFERROR formula.

If the can only exist on one sheet or the other (but never BOTH at the same time), then your formula should be fine.
(It isn't really clear from your original question if this is the case or not).