Multiple Values

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hello

I'm trying to lookup and return a value but based on two conditions being
satisfied.
I key a code into A21 and a Length into F21 and return a value from the
lookup table.
So: If A21 and F21 are found in the lookup table then return the value in
R4:R158
Similarly, if A21 and H21 are found return the value.

I've attached a piece of the spreadsheet that I hope will help explain

Many thanks for taking the time

Rob
 
I've attached a piece of the spreadsheet
that I hope will help explain
Click to expand...

I don't see any sample data and without it I don't think your explantion
will be enough to try to figure out what you want to do.
 
It would be best to send you the attachment but that doesnt appear possible.
thanks anyway Biff
 
Back
Top