Next Column over

  • Thread starter Thread starter tubeman
  • Start date Start date
T

tubeman

Is there something where I could perform a vlookup and after my looku
finds a cell that matches I need it to look into the cell immediatel
beside it and perform another match and if that match is successful
need it to post an answer to the cell with the formula with the cel
beside the final match and if not i need it to pass this point an
start the process over beyond this point. beyond this point meaning
need it to vlookup the next match for the cell and start the proces
over intil both match and there is an answer, and if the whole shee
does not have the answer then post 0 to the formula cell.

And Frank from Germany, I apprecaite all your help
 
You need to study the MATCH and INDEX functions in HELP index.
Use match to find the row and then use it within an index function to find
the column info
 
sounds like an if -fx- , something like...

=if(vlookup(a1,f1:h5,2,0)="","",if(vlookup(c1,f1:h5,3,0)="",0,vlookup(c1,f1:h5,3,0))

untested. but would go into b1, range to lookup would be f1:h5. don'
know if i'm reading your question right or not though.

HT
 
Back
Top