Is this possible

  • Thread starter Thread starter triple_juicy
  • Start date Start date
T

triple_juicy

I have 2 workbooks saved in a workspace. One is a cash book and th
other is to analyse each column in the payment sheet of the cash book.
I am looking for a formula that will look for a value (text) in th
description column (B1) of the cash book and find the numerical valu
in the gross column (D1) of the cash book and return the numeric valu
in the analysis work book. I would try the match function but i
returns only the position of a value and the vlookup don't seem t
work.

Please help!!!!
 
Vlookup might not work as desired if not sorted. So use
=vlookup(a1,b2:z200,2,false).Or use match to find the row within a column
and then use it inside an index formula instead of lookup.
 
Back
Top