Modification of a VLOOKUP formula

[meppwc]

I am trying to add on to a VLOOKUP formula but I have no idea if there is a way to make this work.

The lookup table is on worksheet “Table” in column A. Each value in column A is a 6-digit number. In column B of the “Table” worksheet are values of either “Yes” or “No” that relate to each of the 6-digit values in the Column A lookup table.

The VLOOKUP formulas are on worksheet “tblAvailableItems” starting in cell M2 (=VLOOKUP(H2,Table!A:A,1,FALSE).

Currently the formula works correctly and either returns the 6-digit numeric string if found, and returns #N/A if not found.

What I would like the formula to return is the value found in column B of the “Table” worksheet next to the value found in the table. This would be values of either “Yes” or “No”.

 

[Tetra201]

Try

=VLOOKUP(H2,Table!A:B,2,FALSE)

 

[Aladin Akyurek]

That would be:

=VLOOKUP(H2,Table!A:B,2,FALSE)

or

=VLOOKUP(H2,Table!A:B,2,0)​

_{^{<strike>
</strike>}}​

 

[meppwc]

EXCELLENT...........thank you gentlemen