Thread: Look up formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_3_] Shane Devenshire[_3_] is offline
external usenet poster
 
Posts: 10
Default Look up formula

Hi,

How does it know which "previous tab" to pick? How does it know which
column to pick?

If we say Yes, is that good enough?

If you want a suggested formula you would need to show us samples of the
data in the tab you are entering the formula in and other details. For
example, is it looking for the word by itself in a cell or is the word part
of a sentence? Does it make any difference what the word is, or on what row
it finds it? Is this search case sensitive or not?

The general formulas for the last item in a column a

=INDEX(C3:C19,MATCH(TRUE,C3:C19<""))
=LOOKUP(9^9,C3:C21)
=LOOKUP(2,1/(B:B<""),B:B)
=LOOKUP(REPT("z",255),B2:B21)
=LOOKUP(9^9,IF(C3:C150,C3:C15))

Of course which one you choose depends on your data.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chel" wrote:

Is it possible to write a formula that #1 has to look in a column for a
specific word and then if it is there then #2 goes to a previous tab and
grabs the information that is the last thing typed in that column?

Hope this makes sense.

Many thanks