Populating Data from Table into cell based on String Entry from separate cell

[mpetersen1027]

Apologies, I cannot seem to find an answer. Probably due to a lack of terminology knowledge.

Attached is an .XLS which has two tabs. (Entry Tab, Table Tab)

When users enter a location name into a cell - the expected result is for an office code to populate in a separate cell.

Entry Tab
This is where users will enter a location name into a cell and an office code will populate in a separate cell.

Table Tab
Table that contains location names and the corresponding office codes.

On the ENTRY TAB - Column B - users manually enter the location name. (With the assistance of thee appropriate formula) In column E, the corresponding office code will automatically populate.

Example on Attached .XLS
On ENTRY TAB
In Cell B2
User has entered the location name of "Applewood"
According to TABLE TAB: Applewood is assigned to Office Code "100"
In Cell E2 "100" should populate

Hopefully this makes sense - please advise if there are questions or clarifications.

[Estevaoba]

Try
=VLOOKUP(B2,'Table Tab'!$A$2:$B$100,2,0)

[mpetersen1027]

thanks for the quick response... I can decipher about 90% of this formula, except for the last two integers ,2,0) what do those last integers mean/do? Thank you.

[Estevaoba]

You're welcome. Glad to help.

The formula is based in two columns, A & B.
The argument ",2" represents the column number to get value from.
The argument ",0" specifies teh type of search: 0 or FALSE for an exact match, and 1 or TRUE for an approximate match. In your case, I think you want an exact match.

More details in this page:
https://support.microsoft.com/en-us/...8-93a18ad188a1