V Lookup

[Sue]

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

 

[Niek Otten]

Hi Sue,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
|
|
|
|
|

 

[Sue]

Sorry - I left off a column heading.

 

[Chi]

Hi Niek,

It works!!!!

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

Thank you
Chi

 

[Niek Otten]

The cell was formatted as text before you entered the formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
| >
| > |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
| > |
| > |
| > |
| > |
| > |
| >
| >
| >

 

[Chi]

Hi Niek,

Thank you so much!
Chi