Thread: Multiple Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Multiple Values

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