help to adjust this formula

  • Thread starter Thread starter jladika
  • Start date Start date
J

jladika

=VLOOKUP(A1,$J$1:$K$3,FALSE)


I would like my search to not have a end
is there a way to keep it open.

when i add new patients to this list do i have to keep changing th
$k$3 ?


what does $ mean
false mean
thanks
jo
 
The $ means the address is absolute rather than relative - see "The
difference between relative and absolute references" in XL Help.

One way to modify your formula:

=VLOOKUP(A1,$J:$K,2,FALSE)
 
need to back up a minute


my spreadsheet is ongoing
i add new and old patients on it all the time
do i have to have another sheet to have this infromation on
or can i get it from the same spreadsheet
 
I think you'd be much better off moving that data to a new worksheet (in the
same workbook).

Then you won't have to worry about deleting rows/copying rows or anything else
that can mess up that lookup table.

=VLOOKUP(A1,sheet2!$A:$B,2,FALSE)

might be better.
 
Back
Top