LinkBack URL
About LinkBacks
Here's a sample of what i want to happen:
SAMPLE.png
Here's a sample of what i want to happen:
SAMPLE.png
Hi there,
instead of posting pictures, pls post sample workbook...
Thnx
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
i dont know how to post a sample workbook
Last edited by kittle08; 05-23-2014 at 02:41 AM.
Hi kittle,
You can use following formula:
Formula:
Please Login or Register to view this content.
According to Your sample workbook, copy this formula to cell B3. Note, that this is an array formula and needs to be confirmed by Ctrl+Shift+Enter, NOT just Enter.Then drag it down.
Adjust ranges according to Your needings, and It should work correctly. Maybe you have to change the end of formula '-9' when Your source table starts on different row.
Hope it helps
Last edited by Miroslav R.; 05-23-2014 at 03:28 AM.
Thank you!
btw, i tried the formula when the data for "stocks" and "units" are in another sheet, it doesn't seem to work..how do we remedy this?
btw, i tried the formula when the data for "stocks" and "units" are in another sheet, it doesn't seem to work..how do we remedy this?
Here's another one.
Data Range
This formula entered in B3 and copied down:
=LOOKUP(2,1/(B$10:B$16=A3),C$10:C$16)
If the data is located on another sheet just include the sheet name. For example:
=LOOKUP(2,1/(Sheet2!B$10:B$16=A3),Sheet2!C$10:C$16)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks