V Lookup
 

I have a workbook that I am trying to use a V- Lookup and all Excel returns
in the cell is the formula, no results. The formula is:
=VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
ascending - 1st column. Any ideas why Excel will only return the formula, not
the result?

The main table has the following columns:
A1 B1 C1 D1 E1
F1
Pt Last Name Pt First Name CLINIC# Gender Provider Dept.

My table array contains column headings and data:
A1 B1
Provider Dept.

ACM MONT
AMZ NCE3
AVB NCW2
BCB S5AM
BEE SEUR
BG CHN1

V Lookup
 

Hi Sue,

Format the cell with the formula as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue" wrote in message ...
|I have a workbook that I am trying to use a V- Lookup and all Excel returns
| in the cell is the formula, no results. The formula is:
| =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
| ascending - 1st column. Any ideas why Excel will only return the formula, not
| the result?
|
| The main table has the following columns:
| A1 B1 C1 D1 E1
| F1
| Pt Last Name Pt First Name CLINIC# Gender Provider Dept.
|
| My table array contains column headings and data:
| A1 B1
| Provider Dept.
|
| ACM MONT
| AMZ NCE3
| AVB NCW2
| BCB S5AM
| BEE SEUR
| BG CHN1
|
|
|
|
|

V Lookup
 

Sorry - I left off a column heading.

"Sue" wrote:

I have a workbook that I am trying to use a V- Lookup and all Excel returns
in the cell is the formula, no results. The formula is:
=VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
ascending - 1st column. Any ideas why Excel will only return the formula, not
the result?

The main table has the following columns:
A1 B1 C1 D1 E1 E2
F1
Pt Last Name Pt First Name CLINIC# Gender Provider Dept.

My table array contains column headings and data:
A1 B1
Provider Dept.

ACM MONT
AMZ NCE3
AVB NCW2
BCB S5AM
BEE SEUR
BG CHN1

V Lookup
 

Hi Niek,

It works!!!!

Would you please tell us, Sue and me, what the problem was?

Thank you
Chi

"Niek Otten" wrote:

Hi Sue,

Format the cell with the formula as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue" wrote in message ...
|I have a workbook that I am trying to use a V- Lookup and all Excel returns
| in the cell is the formula, no results. The formula is:
| =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
| ascending - 1st column. Any ideas why Excel will only return the formula, not
| the result?
|
| The main table has the following columns:
| A1 B1 C1 D1 E1
| F1
| Pt Last Name Pt First Name CLINIC# Gender Provider Dept.
|
| My table array contains column headings and data:
| A1 B1
| Provider Dept.
|
| ACM MONT
| AMZ NCE3
| AVB NCW2
| BCB S5AM
| BEE SEUR
| BG CHN1
|
|
|
|
|

V Lookup
 

The cell was formatted as text before you entered the formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chi" wrote in message ...
| Hi Niek,
|
| It works!!!!
|
| Would you please tell us, Sue and me, what the problem was?
|
| Thank you
| Chi
|
| "Niek Otten" wrote:
|
| Hi Sue,
|
| Format the cell with the formula as General and re-enter the formula (F2, ENTER)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Sue" wrote in message ...
| |I have a workbook that I am trying to use a V- Lookup and all Excel returns
| | in the cell is the formula, no results. The formula is:
| | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
| | ascending - 1st column. Any ideas why Excel will only return the formula, not
| | the result?
| |
| | The main table has the following columns:
| | A1 B1 C1 D1 E1
| | F1
| | Pt Last Name Pt First Name CLINIC# Gender Provider Dept.
| |
| | My table array contains column headings and data:
| | A1 B1
| | Provider Dept.
| |
| | ACM MONT
| | AMZ NCE3
| | AVB NCW2
| | BCB S5AM
| | BEE SEUR
| | BG CHN1
| |
| |
| |
| |
| |
|
|
|

V Lookup
 

Hi Niek,

Thank you so much!
Chi

"Niek Otten" wrote:

The cell was formatted as text before you entered the formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chi" wrote in message ...
| Hi Niek,
|
| It works!!!!
|
| Would you please tell us, Sue and me, what the problem was?
|
| Thank you
| Chi
|
| "Niek Otten" wrote:
|
| Hi Sue,
|
| Format the cell with the formula as General and re-enter the formula (F2, ENTER)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Sue" wrote in message ...
| |I have a workbook that I am trying to use a V- Lookup and all Excel returns
| | in the cell is the formula, no results. The formula is:
| | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted
| | ascending - 1st column. Any ideas why Excel will only return the formula, not
| | the result?
| |
| | The main table has the following columns:
| | A1 B1 C1 D1 E1
| | F1
| | Pt Last Name Pt First Name CLINIC# Gender Provider Dept.
| |
| | My table array contains column headings and data:
| | A1 B1
| | Provider Dept.
| |
| | ACM MONT
| | AMZ NCE3
| | AVB NCW2
| | BCB S5AM
| | BEE SEUR
| | BG CHN1
| |
| |
| |
| |
| |
|
|
|