Formula Question

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

I need to create a formula that will find text and then return the number.
See below.

LOC STAT FACILITY PROF
ADJ VOID 0 0
COB COB 0 0
COB LNLVL 0 0
COB MED 0 34
COB PEND 0 0

I need the formula to find the matching STAT text and then return the value
found in FACILITY OR PROF field. The STAT fields are not always in the same
cell but arei n the same column (B).

Can anyone help me?
 
Hi Stephanie,

VLOOKUP is your first choice:

Suppose you put the value you want to look up in cell A1 and suppose your
table starts in D1:

Then in A2 enter the formula
=VLOOKUP(A1,E2:G7,2,FALSE)

The first column that the vlookup is concerned with is the Stat column, not
the Loc column so the reference to E2 not D2. The 2 argument means return
the value from the second column of the E2:G7 range, here the FACILITY
column. 3 would mean the Prof column. The FALSE at the end means you want
an exact match.
 
Back
Top