LinkBack URL
About LinkBacks
attach file
I want values in sheet 2 column type as A-1 .........E1 etc.
Please help
attach file
I want values in sheet 2 column type as A-1 .........E1 etc.
Please help
Soory, I don't understand what the result you want is. can you explain a bit more clearly...
Hi,
If you are comparing the 'Pipe Diameter' in two tabs, you have multiple 'Type' fields for each Diameter (Sheet1). Please provide some logic in filling up the 'Type' field in Sheet2.
If the pipe diameter falls between the two given on sheet 1, then that's the diameter needed on sheet 2, surely?Originally Posted by cbatrody
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
in sheet2!b6 filled down
=INDEX(INDEX(Sheet1!A:A,MATCH(A6,Sheet1!B:B,0)):INDEX(Sheet1!A:A,MATCH(A6,Sheet1!B:B,0)+3),MATCH(B6,INDEX(Sheet1!C:C,MATCH(A6,Sheet1!B:B,0)):INDEX(Sheet1!C:C,MATCH(A6,Sheet1!B:B,0)+3),1))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
OOPS just noticed A has more ranges than the rest then last formula wont work
try
=LOOKUP(A6,{300,400,500,600,700,800,900,1000},{"A","B","C","D","E","F","G","H"})&"-"&IF(A6=300,MATCH(B6,{0,1.5,2.5,3,4},1),MATCH(B6,{1.5,2.5,3,4},1))
Last edited by martindwilson; 05-04-2014 at 05:27 AM.
Thank you very much
Great reply thanks
Another variation...
On sheet2, in B6, try this array formula which requires confirmation with Ctrl+Shift+Ente instead of just Enter. (i.e. hold down the Ctrl+Shift and then press Enter.)
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks